Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to make a truly "blank" worksheet: No gridlines, invisible cells?

Status
Not open for further replies.

mackinmn

Technical User
Mar 16, 2001
6
US
My worksheet has invisible gridlines. Now I would like to control the visibility property of all the cells in my worksheet. I want all the cell values and formulas to exist, but remain invisible to the user during certain tasks. I would prefer NOT to hide all the columns or rows because certain columns must remain hidden, depending on the task performed.

In short, I want the screen to be all white with just a few macro buttons showing. Has anyone ever tried this?

Thanks,
MackInMN
 
Never mind... I decided it would be easiest to simply record a macro where I click "all cells", then change the font to white.

Sometimes I tend to overthink things. Thanks anyway:)

Cheers,
MackInMN
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top