Welcome to the Forum
Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.
Welcome to the Forum
Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.
I tried similar code, but, as in Carim's example, the macro doesn't run but you simply end up selecting the button.
Unfortunately, I don't think disabling the button stops the assigned macro from running.
You need to amend the macro to check A1's value.
Done some more experimenting and this works
I t doesn't seem you can disable forms control buttons now. I've tried various codes with no luck.
I've edited the code slightly
Try this. I've left all the options that you can change in the PageSetup for reference. I haven't checked it so let me know if it needs any amendments
Pleased to help.
Post back if you need further help.
Visit my web site, http://www.excel-it.com, for more examples and some helpful articles.
I haven't used it but it's better than relying on macros. Do a trial and post back here.
The only efficient way to share a workbook is to use Collaboration, unfortunately it is only available if you use Office 365
If you want to adjust multiple sheets within each workbook use
Try this. The code assumes each workbook has one sheet.
QuoteTried running the code and it is basically a dead duck
That doesn't provide any help as to why it's not working. Twice I've asked to see the workbook!
As I said, it would help to see your workbook.
This will add a unique identifier based on the time it is saved. Note that you must reset DisplayAlerts as well
It would help to see your file
What range cannot be found?