macros code permanently enable, how......?

[aliasger.q]

i have one excel file in which i have design some macro code but when i double click that file fistly ask the security warning with disable, enable and help tab.

so is it possible....? without asking me that box i want to open excel file with macros running code

how can i fix that problem.


can any one help me.

thanks

 

[prasaddn]

Hi Aliasger.Q


This is designed feature to protect against malicious programs. Hence, it is not possible to auto-enable.


The only workaround is to keep the blank sheet open with message or screen shots showing who to enable to macros and what to answer for pop ups.


hide this sheet under workbook open event. so, when macros are enabled you would not see this sheet.


Regards,

Prasad DN

 

[Luke M]

Office Button - Excel Options - Trust Center. Click on Trust Center Settings, and then either adjust Macro Settings, or add the folder that the file is in to your Trusted Locations settings.

 

[Istiyak]

Ninjaa'''''


Great...


Regards

!$T!

 

[aliasger.q]

Hello prasad dn

here the way you explain me its very nice and draw attraction. so please could you tell me how to do this. i am very need full for this.


thanks

 

[Luke M]

Rough outline of prasaddn's idea.

1. Create a "splashpage" where users will land if macros aren't enabled. Put a relevant message on this page.

2. Create a Workbook_Open event macro that looks like this:

[pre]

Private Sub Workbook_Open()
For Each ws In ThisWorkbook.Worksheets
ws.Visible = True
Next ws
Worksheets("Splashpage").Visible = False
End Sub

[/pre]
Make sure you put this in the ThisWorkbook module.


3. Hide every sheet except for the splashpage and save workbook. If user has macros enabled, other sheets will unhide and never see splashpage. Otherwise, they will only see the splashpage, and know they need to close and re-open w/ macros enabled if they want to use the workbook correctly.

 

[prasaddn]

Thank you Luke M

 

[aliasger.q]

Hello Mr Luke M, & Prasad dn,


Thanks allot, Now its clear to me.