hiding tabs until macros are enabled

[FaurKris]

The code below (found online and then altered) has allowed me to prompt the user if any cells are left blank, and it works well. However, the user can disable the macros and get around having to complete the needed data.

I've been trying to find a code that will work with this so I can have the workbook open to a cover page (hiding all the other tabs) asking the user to open with the macros enabled.

Because I'm unable to freely design VB code, I've been finding volunteered codes online and trying to alter them to work. So far I haven't been able to actually hide the tabs (3 of them) if opened with macros off.

Can someone please help me write a code or send me a sample I can play with to be able to do this? We use version 2003 currently.

Code is in "ThisWorkbook." Option Explicit is in "General/Declarations" and the rest is in "Workbook/BeforeSave."

Please Login or Register  to view this content.

Thank you!

[TMS]

Hide the tabs in the Workbook_Before_Close event.

They are then already hidden when the workbook is opened ... so you have to activate macros in order to unhide them. Set them to Very Hidden rather than just hiding them and protect the VB Project with a password.

Regards

[FaurKris]

Can you help me out with an example code?

"I'm unable to freely design VB code."


Thanks a ton!!

[MarvinP]

Hi FaurKris,
Find the attached with code that will hide all tabs except the first one when the workbook closes. The code looks like:

Please Login or Register  to view this content.

[FaurKris]

ONLY the first tab shows up.....?

[MarvinP]

Yep - that is because in the For Loop I started with ShtCtr = 2.

The code uses the Tab Index numbers and hides all the Tabs except the left-most Did you want to hide ones with special names?

[FaurKris]

No, I just want to hide all but the first tab, but ONLY if the user disabled macros. Otherwise, I would want all but the first tab to appear. I've made the first tab to be like a cover page telling the user to stop and enable macros.

Oh, and I pasted your code and nothing changed on my spreadsheet. I only noticed the single tab on yours. The operation of my spreadsheet did not change.

[ChemistB]

What Marvin's code does is hide all the tabs but it does not make them "very hidden" If you want the tabs to automatically reverse on opening (if the person enabled macros), then you need more code. Try these two macros in "This Workbook"

Please Login or Register  to view this content.

Does that work for you?

[MarvinP]

When you pasted my code, did you put it behind the Workbook module?

[FaurKris]

Here are the screen shots of what I have...

The file is still opening with all tabs showing when I elect not to enable macros.


I appreciate all the help. Hopefully I can get this sorted soon...

[FaurKris]

Okay, so I just noticed that when macros are enabled and I am asked to save, All the tabs are closed but the first one....... But that is the only time that happens.

[TMS]

Maybe try:

Please Login or Register  to view this content.

Regards