LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Makro from value in one cell, hiding columns in another sheet

Hi,

I do not have much experience in macro programming, but now I would need to
make a macro. Can someone please help me??

In one excel worksheet called "Menu" I have put a lookup function in cell
(A5). This function presents values 1 to 12 (and cell B5 has a similar lookup
function presenting month January to December), depending on value chosen in
a drop down list. If value in cell A5 is 1 (January in cell B5), I would like
to hide some columns in another worksheet called "Output", say columns U to
Z. I think that for hiding the columns I can use:

Columns("U:Z").Select
Selection.EntireColumn.Hidden = True

But I don't know how to start this macro, I don't know how to do the
selection of columns depending on the value in cell A5(can I use an IF
function?), and how to select the worksheet "Output"?? Can someone please
help?

Thanks a lot,
Kristine
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Hiding rows or columns based on cell contents Bill H Excel Discussion (Misc queries) 3 December 16th 08 10:19 PM
Hiding columns in a protected sheet wtebra Excel Discussion (Misc queries) 4 September 29th 08 04:17 PM
hiding columns, error message says cannot shift objects off sheet JORGE ORTIZ Excel Discussion (Misc queries) 11 August 19th 08 10:34 AM
when hiding columns mess: "cannot shift objects off sheet" KM Excel Discussion (Misc queries) 1 August 4th 06 02:01 AM
Hiding columns, custom views, protected sheet Ian Excel Discussion (Misc queries) 0 May 4th 06 09:59 AM


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"