Disable Save As just for opened workbook

D

Daniel Wright

Hi,

I'm creating vb scripts dynamically which open up excel workbooks. This
means that I can't use the excel events as the script is deleted once it
has opened up the file. On open the script disables the save as button.

The problem is that when the user exits the workbook, excel now defaults
to have save as disabled so when Excel is opened up the save as button
cannot be reached?....

Any help would be great

Thank you

Daniel.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

security, enabling macros to enable a disabling saving function 12
Custom ribbons dissapear when saving?!? 0
Lose macros before saving 4
All Workbook Saved except This Workbook 3
userform on intranet: disable save button on initial launch 3
Passing a Parameter to the workbook open macro 1
button for saving all workbooks 6
All Workbook Saved except This Workbook - Part2 3

Top