CODEWITHSUNDEEP
vbaexcel
BobSki
BobSki

Reputation: 1552

Hide workbook/worksheets Excel VBA

I have a simple Microsoft Excel spreadsheet with a few tabs. On opening the workbook I have a USER LOGIN form that loads up and asks for login and password. What I'm trying to do is somehow not let the user see the sheets in the workbook until they've successfully logged in. The problem I'm seeing is that one of my sheets has a macro in it, so what I do

sheet1.visible=xlhidden

it gives me a debug error. However, even if I skipped that sheet and hid all the other ones - and on proper login I tried to make them Visible=xlVisible, they still did not become visible. How would I go about something like that?

Is there some kind of a way to be able to hide the workbook possibly and then make it visible after successful login?

Upvotes: 0

Views: 938

Answers (1)

user6432984
user6432984

Reputation:

xlhidden is not an acceptable value for Worksheet().Visible.

  • Sheet1.Visible = xlSheetVisible makes the Worksheet visible
  • Sheet1.Visible = xlSheetHidden: hides the Worksheet but allows users to unhide it

  • Sheet1.Visible = xlSheetVeryHidden: hides the Worksheet and prevents users from unhiding it

    enter image description here

Upvotes: 2

Related Questions