Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
Is there a VBA macro statement that will select a custom view? I'd like
to assign such a macro to a button. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
hi
ActiveWorkbook.CustomViews("myview").Show regards FSt1 "Kent McPherson" wrote: Is there a VBA macro statement that will select a custom view? I'd like to assign such a macro to a button. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
ActiveWorkbook.CustomViews(-nameOfCustomView-).Sho -- TommySzalapsk ----------------------------------------------------------------------- TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556 View this thread: http://www.excelforum.com/showthread.php?threadid=39090 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
How about hiding particular worksheets by clicking on buttons to hide them? In other words, I have worksheets A, B, C, D, & E. I want to have buttons that say "Hide A", "Hide B", etc. Or maybe set up a checklist that shows which sheets to hide or show. I want the user of the spreadsheet to be able to customize what he/she actually sees. Thoughts? *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
FSt1 wrote:
hi ActiveWorkbook.CustomViews("myview").Show regards FSt1 "Kent McPherson" wrote: Is there a VBA macro statement that will select a custom view? I'd like to assign such a macro to a button. How about hiding particular worksheets by clicking on buttons to hide them? In other words, I have worksheets A, B, C, D, & E. I want to have buttons that say "Hide A", "Hide B", etc. Or maybe set up a checklist that shows which sheets to hide or show. I want the user of the spreadsheet to be able to customize what he/she actually sees. Thoughts? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to select a view
Worksheets(-nameOfSheet- ).Visible = Fals -- TommySzalapsk ----------------------------------------------------------------------- TommySzalapski's Profile: http://www.excelforum.com/member.php...fo&userid=2556 View this thread: http://www.excelforum.com/showthread.php?threadid=39090 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to select cells without a certain value and select a menu it | Excel Worksheet Functions | |||
how to view a macro | Excel Discussion (Misc queries) | |||
View, scroll and select a cell value from another Excel sheet? | Excel Worksheet Functions | |||
XLS Worksheet 'Select All' button + top 2 rows not in view in wind | Excel Discussion (Misc queries) | |||
Select other workbook to select data in a macro. | Excel Programming |