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

[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...

 

[Bob Phillips]

Can't you just remove the code from that file?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Private Sub Workbook_Open()
if thisworkbook.Path <> "" then exit sub
' current code
End sub

 

[areddy]

Thanks to all of them.

and thanks Tom Ogilvy..

i will try that option..

Regards,
Amar...