Another disclaimer question

**McFarland Johnson** · 02-09-2011, 12:13 PM

I found the previous post with the disclaimer code and it's what I would like to use BUT the problem I have is if the user has Macros disabled the data in the excel sheet still is viewable. Is there a way to make it so that if they have the Macros disabled they get nothing?

Basically I need a file to open and they have to accept to enter the document, if they decline or X out of the disclaimer it closes the document.

The trick is, if they have their excel environment set to disable macros my disclaimer is not showing up and all the data in the excel file is viewable.

Anybody know how I can fix this?

**martindwilson** · 02-09-2011, 12:24 PM

doesnt matter what you do it will always be editable by anyone who knows how!

**Domski** · 02-09-2011, 12:35 PM

You could use code like this to 'force' people to enable macros but as Martin says if people know Excel well enough it's easy enough to get round.

Dom

**McFarland Johnson** · 02-09-2011, 12:44 PM

Thanks for the replies - Yes I'm aware that people that really know Excel can get around it, the same goes for almost anything in the computer world.

My boss just specifically wanted it so that if Macros were Disabled it would not show the data and I think what you linked me to should work just fine. I'm gonna test it out.

thanks again

**McFarland Johnson** · 02-09-2011, 03:56 PM

could one of you please be so kind as to show me how to merge these two pieces of code?

in my searches I have found a piece of code that will work for my disclaimer, and as you pointed me to earlier I was able to find a piece of code to use as my Macro Enabler - but I can't seem to find a way to make them work together.

What I need is, when the document first opens it needs to check and make sure the macros are enabled. If they are not then it shows the message on the "prompt" page that they need to enable macros.

If the Macros are already enabled OR After the Macros are enabled by the user, it then needs to open the disclaimer page, from there if they select "accept" it will allow them into the document, and if they select decline it will kick them out of the document.

I have read thru both pieces of code and I just can't seem to figure out where each piece needs to be to merge them together. Seperately they do exactly what I need them to do, now I just need them to run together.

after these documents are merged then I should be able to add the data and sheets I need to run my file

If somebody could help me out I'd appreciate it.

**McFarland Johnson** · 02-09-2011, 04:05 PM

I'm getting a little farther - I'm able to make it run once, then when I try to run it again it has a debug error. After It runs the code it sets the "Start Page" to veryHidden causing the next run to throw a debug error. If I set the "Start Page" to visible it runs again.