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

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

--

HTH

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


"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

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

Thanks to all of them.

and thanks Tom Ogilvy..

i will try that option..

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