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

[Kaak]

Your can remove code from a workbook from vba code.

Put the code in :

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)



End Sub

[Bob Phillips]

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

--

HTH

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


"areddy" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Tom Ogilvy]

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


--
Regards,
Tom Ogilvy


"areddy" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[areddy]

Thanks to all of them.

and thanks Tom Ogilvy..

i will try that option..

Regards,
Amar...