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 Westi 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 worksheet complete white? 1

Status
Not open for further replies.

feipezi

IS-IT--Management
Aug 10, 2006
316
US
Hi,
I don't want to use Format Cells -> Patterns to do it because it can be undone by changing white to other colors. I have a sample. The sample I have cannot be changed by Format Cells at all. I tried Format Cells -> Border to take no border option but not working.
Can VBA help in this kind of situation?
Thanks in advance.
john z.
 





This is not a vba question.

Tools > Oprions > View Tab: GRIDLINES.

Use your macro recorder. There are very few things that VBA can do that you cannot do manually on a sheet.

Skip,

[glasses]Just traded in my old subtlety...
for a NUANCE![tongue]
 
Skip,
The way you told me really works.
Thanks alot!
John Z.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top