Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone. I have a problem.
I would like to hide a sheet and make it active only with the clik of a button.
How do I do?
Once I used this for that purpose.
It is a double check. First you have to open Sheet Properties and Show it conditionally to these 2 variables: Contraseña (Password) and Pase (Pass). Also, it is convenient to hide tabs. Using this method, the sheet will not appear in the tool bar Sheets. I´m sure they are other ways. For example by user.
sub contrasena
Dim PassBox
Dim Lowercase
PassBox = InputBox("Por favor, escriba la contraseña", "Contraseña")
set w = ActiveDocument.Variables("contrasena")
set v = ActiveDocument.Variables("pase")
if PassBox = w.GetContent.String then
v.SetContent "si" , true
ActiveDocument.ActivateSheet "Administracion"
Else
MsgBox "Contraseña Incorrecta", , "Contraseña"
End if
end sub
Hello Marco,
If you don't need additional security, and you only want to show/hide a sheet (instead of an object) using only one button, do the following:
=If(vSheetVisible = 1, 'Hide Sheet', 'Show Sheet')
=If(vSheetVisible = 1, 0, 1)
vSheetVisible = 1
And that's all.
Hope that helps.
BI Consultant
Thank you boys,I reolve the problem