+ Reply to Thread
Results 1 to 2 of 2

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

Hybrid View

areddy I don't want to run visual... 10-26-2005, 06:32 AM
swatsp0p Untested, but try this: ... 10-26-2005, 08:57 AM
  1. 10-26-2005, 06:32 AM #1
    areddy is offline
    Registered User
    Join Date
    10-19-2005
    Posts
    38

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

    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...
    Reply With QuoteRegister To Reply
  2. 10-26-2005, 08:57 AM #2
    swatsp0p is offline
    Forum Expert swatsp0p's Avatar
    Join Date
    10-07-2004
    Location
    Kentucky, USA
    MS-Off Ver
    Excel 2010
    Posts
    1,545
    Untested, but try this:

    Open Excel
    Click Tools>Options
    On the Security tab, click "Macro Security"
    Set to HIGH, click OK

    Now open your saved workbook

    Macro should not run....

    When finished, repeat steps and return Macro setting to previous state.

    Does this work for you?
    Bruce
    The older I get, the better I used to be.
    USA
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1