| 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
|
|
#4
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 *** |
|
#5
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? |
|
#6
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 |
|
#7
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 |
| 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 | |||
![Kent McPherson[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
