I don't want to run visual basic editer code after saving...

  • Thread starter Thread starter areddy
  • Start date Start date
A

areddy

Hi All,

Iam writing some code to disable some controls in excel visual basi
editor under Workbook_Open() function for one particular exce
template.
It is working fine.all controls are disabled when i open the excel.
now i used "save as" option and saved in some folder.

Now the problem is coming. I want to open the saved file i don't wan
to run the Workbook_Open() code because i don't want to disable th
controls for saved excel file.

Regards,
Amar..
 
Untested, but try this:

Open Excel
Click Tools>Options
On the Security tab, click "Macro Security"
Set to HIGH, click OK

Now open your saved workbook

Macro should not run....

When finished, repeat steps and return Macro setting to previous
state.

Does this work for you?
 

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

I don't want to run visual basic editer code after saving... 3
Saving problems 1
visual basic code in 2003 vs 2007 1
VBA codes 4
Notepad Visual Basic and Excel 7
Run "Workbook Open" once 5
Visual Basic code not working when sheet is saved 3
Control Box help - visual basic 2

Back
Top