How to avoid the file that conatain macros

  • Thread starter Thread starter kvenku
  • Start date Start date
K

kvenku

Hi,
I am using a Excel application which inturn contain a macros tha
automatically create a tool bar when the file opens. On click of th
new icon on the toolbar a commondialog appers where i can choose so
excel files. Actually i shouldn't access the excel files that contain
macros. How to trap the xls that conatin macros.

can you send me some VBA codes to trap.
Please help me out

Thanks

venkates
 
Vencatesh,

No code required, this is standard Excel functionality! Set your Excel macro
security (Tools > Macros > Security) to Medium. Whenever you attempt to open
a workbook you will be warned if it contains macros, and be given the
options to (a) open enabling the macros, or (b) open with the macros
disabled, or (c) not open at all (by closing the dialog box from the little
X button on the top right hand corner).

HTH,
Nikos
 
Back
Top