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


--
Regards,
Tom Ogilvy


"areddy" wrote in
message ...

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


--
areddy
------------------------------------------------------------------------
areddy's Profile:
http://www.excelforum.com/member.php...o&userid=28204
View this thread: http://www.excelforum.com/showthread...hreadid=479392