+ Reply to Thread
Results 1 to 2 of 2

Is that safe to save excel file in "macro-enable" ?

  1. #1
    Forum Contributor
    Join Date
    03-19-2010
    Location
    singapore
    MS-Off Ver
    Excel 2019
    Posts
    177

    Is that safe to save excel file in "macro-enable" ?

    i m going to add some shortcut key and some VB into my excel file, but it must enable the macro. I want to know is that safe if i save the file in macro-enable" ? What will be happen?

    thanks

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Is that safe to save excel file in "macro-enable" ?

    Not sure what you mean. If you add VBA cide to any Excel 2003 workbook then when you re-open it you will be asked to enable macros. If you don't the code can't work.

    Macro Security should be set to Medium, higher than this will automatically stop code from running. Lower & you will not be prompted for code will run, but dangerous or unwanted code will run automatically too
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1