Disabling Tabs

[alan dresch]

I have added a line of VBA to open my workbook at a specific sheet - I
have tabs 'switched' off.

This sheet has a Button and Macro to ENTER the rest of the workbook.
The problem with this simple form of security is that if the user
saves a workbook after enabling Tabs in Tools/Options/View, the
workbook on opening will have tabs enabled and they can bypass my
ENTER sheet.

Is it poosible to disable Tabs?

All the best

Alan

 

[Bob Phillips]

Alan,

In the open code that sets to a worksheet, add this line

ActiveWindow.DisplayWorkbookTabs = False

so even if they do, you reset on re-opening.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Why not make the setting in the beforeSave event

ActiveWindow.DisplayWorkbookTabs = False

Chip Pearson's page on events if you are not familiar with them:
http://www.cpearson.com/excel/events.htm