unlocking vba so I can unhide sheet

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
How do I unlock VBA code so I can unhide sheet.
Or is there a way to just unhide the sheet?
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

PaddyD

MrExcel MVP
Joined
May 1, 2002
Messages
14,234
depends how the workbook / sheets have been protected / how the sheet was hidden in the first place - more details please...
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
I only know of one way of hiding worksheet that is in vba area where you can set properties of sheet.
Would it be better if I hide columns and protect worksheet, or is there another way to hideworksheet?
 

Kamal Subhani

Board Regular
Joined
Jan 26, 2004
Messages
146
Set the visible propery Of the sheet to 2-Xlvery Hidden from 0-Xl Visisble

lock Ur VBA project by giving a Password

Protect ur Workbook


For Unlocking the VBA password U must know the password .

If u forgor buy a software from www.elmsoft,com
or (coslty one)
Passware KIT 6.1


They will open the VBA password

It will sove ur problem

I think


Regards


kamal
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841

ADVERTISEMENT

I am really sorry but I am confused as to how I would unhide after I do this.
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841

ADVERTISEMENT

Sorry left off thanks.
Thanks!
 

Kamal Subhani

Board Regular
Joined
Jan 26, 2004
Messages
146
After Unlocking The VBa Project
U will be in the Visual Basic Editor

Select the the sheet u want to unhide

see its properties

set the visible property of the sheet to Visible from Xlvery hidden ( from 2 to ) The shhet will be visible

before doing this u have to unprotect the workbook an dthe that specific worksheet if u do without unprotecting the workbook u will get and error


Thanks


Reagards

kamal
 

Joe C

Well-known Member
Joined
Oct 17, 2002
Messages
841
This works perfectly but how do I use VBA to hide very hidden?
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,563
Messages
5,765,123
Members
425,262
Latest member
sabry

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top