Previous Topic Next Topic

Reagerding Macro

Closed
ananth - Apr 28, 2009 at 11:34 PM
 ananth - Apr 29, 2009 at 03:11 AM
Hello,
I am using ofice 2003(Excel).While opening the excel every time i am getting a popup reagarding the enable macro option,what i am doing is setting the security level to min.Then i am not getting the popup.

This is the message i am getting while opening the sheet.

"Macros are disabled because the security level is set to high.To Run the macro change the security level to a lower setting and verify the macros are signed and trusted"

Is there is any solution to write a macro with any javascript,etc so that ,i should not get that popup again

1 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
Apr 29, 2009 at 02:32 AM
Start Excel and go in

Tools > Option > Security > Macro Security > Security Level > Low (Click on Low) OK ....

Now Close & Run Excel again now any file having macro will run without pop up .......
0
ananth
Apr 29, 2009 at 03:11 AM
Started Excel and

Tools > Option > Security > Macro Security > Security Level > Medium (Click on Low) OK ....
thisis the option i went for .

But i want to write a Macro with some code,so that it will not give the pop up.(like Auto_open like that ........)
Any idea reagarding this......
If so please help me..
waiting fo rur reply
0

Similar discussions

Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
How to convert number into text in Excel
boratechandu -
Raj -

9 responses