Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make protected hidden row & column headers appear and rehide based ona cell's value
I need to resize select columns and rows whenever A1="Resize".
Columns and rows are hidden and the sheet is password protected (password="sparrow"). When A1="Resize", I need the hidden row and column headers to appear so another macro I have will adjust select column and row widths and heights. When finished, I need to delete the A1 "Resize" entry and the headers to once again be hidden and protected. Following is the resize macro but it currently does not affect headers: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("A1").Address Then Columns("C:C").ColumnWidth = Range("A1").Value End If If Target.Address = Range("A2").Address Then Rows("3:3").RowHeight = Range("A2").Value End If End Sub Thanks for any help that can be given. Michael |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make protected hidden row & column headers appear and rehide based
ActiveWindow.DisplayHeadings = False
"Michael Lanier" wrote: I need to resize select columns and rows whenever A1="Resize". Columns and rows are hidden and the sheet is password protected (password="sparrow"). When A1="Resize", I need the hidden row and column headers to appear so another macro I have will adjust select column and row widths and heights. When finished, I need to delete the A1 "Resize" entry and the headers to once again be hidden and protected. Following is the resize macro but it currently does not affect headers: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("A1").Address Then Columns("C:C").ColumnWidth = Range("A1").Value End If If Target.Address = Range("A2").Address Then Rows("3:3").RowHeight = Range("A2").Value End If End Sub Thanks for any help that can be given. Michael |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make protected hidden row & column headers appear and rehidebased
Thanks CM. It works as expected.
Michael |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re-post: Code to make sheet very hidden based on date | Excel Discussion (Misc queries) | |||
specify a specific column to input text based on another cell's content | Excel Programming | |||
make column values column headers | Excel Discussion (Misc queries) | |||
How do I make Excel column headers alphabetical... | Excel Discussion (Misc queries) | |||
I forgot my password in a protected column, is it hidden somewhere | Excel Worksheet Functions |