Posted to microsoft.public.excel.programming

Briank

external usenet poster

Posts: 1

Autoexec Macro

I would like to create a macro that, upon opening the
file, looks at each cell in Row two and if that cell has
the term "hide" then the macro will hide that column and
for every column in the range.

Column 1 2 3 4 5 6

row 1 SF LA NY Chi Bos Cle
row 2 hide view hide view view view

Any suggestion on how to code this?

Thank you.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
autoexec macro to run on opening the spreadsheet	lee	Excel Discussion (Misc queries)	2	January 20th 07 02:01 PM
What does "Compile error in hidden module:Autoexec New" mean?	Karla	Excel Discussion (Misc queries)	1	September 28th 05 04:47 PM
Autoexec Macro	Rick	Excel Worksheet Functions	4	August 24th 05 06:15 PM
AutoExec - Enable Macros	Bob Barnes[_3_]	Excel Programming	3	January 18th 04 07:56 PM
AutoExec	George Perchette	Excel Programming	1	October 7th 03 11:30 AM

All times are GMT +1. The time now is 01:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us