| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA to unhide columns
Hi Can anyone give me a code to unhide or autofit columns automaticall when the worksheet is opened? I tried to modify an On entry script I got off the web but can't figur it out. Thank -- shine ----------------------------------------------------------------------- shiney's Profile: http://www.excelforum.com/member.php...fo&userid=2681 View this thread: http://www.excelforum.com/showthread.php?threadid=40070 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA to unhide columns
Shiny ,
You could use like this open event Sheet1.Columns.Hidden = True Sheet1.Columns.AutoFit Thanks Xcelion "shiney" wrote: Hi Can anyone give me a code to unhide or autofit columns automatically when the worksheet is opened? I tried to modify an On entry script I got off the web but can't figure it out. Thanks -- shiney ------------------------------------------------------------------------ shiney's Profile: http://www.excelforum.com/member.php...o&userid=26817 View this thread: http://www.excelforum.com/showthread...hreadid=400706 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CAN'T UNHIDE COLUMNS | Excel Discussion (Misc queries) | |||
| unhide all columns | Excel Discussion (Misc queries) | |||
| can no longer insert new columns & unhide hidden columns | Excel Worksheet Functions | |||
| columns won't unhide | Excel Discussion (Misc queries) | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
Linear Mode
