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 basic
editor under Workbook_Open() function for one particular excel
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 want
to run the Workbook_Open() code because i don't want to disable the
controls for saved excel file.

Regards,
Amar...
 
Can't you just remove the code from that file?

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Private Sub Workbook_Open()
if thisworkbook.Path <> "" then exit sub
' current code
End sub
 
Back
Top