Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Row?
Howdie...
Is it possible to write a formulae to tell whether a row a7 in this eg, is visible or not? I hide it or unhide it depending on what a user selects. I know want to run something else depending if it is hidden or not... and the user needs to be able to alter his choice.... Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Row?
Hi Darin
something along the following lines Sub testvisible() If Rows(7).Hidden = True Then MsgBox "hidden" Else MsgBox "not hidden" End If End Sub Cheers JulieD "Darin Kramer" wrote in message ... Howdie... Is it possible to write a formulae to tell whether a row a7 in this eg, is visible or not? I hide it or unhide it depending on what a user selects. I know want to run something else depending if it is hidden or not... and the user needs to be able to alter his choice.... Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Row?
Sub XXX()
If Range("A7").EntireRow.Hidden Then MsgBox "The row is hidden" Else MsgBox "the row is visible" End If End Sub is a start. You don't say how a user is given a choice or how to determine what the user's choice is. -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Howdie... Is it possible to write a formulae to tell whether a row a7 in this eg, is visible or not? I hide it or unhide it depending on what a user selects. I know want to run something else depending if it is hidden or not... and the user needs to be able to alter his choice.... Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Row?
Howdie...
Thanks... I put it into a VBA module, but where do I see the result....? In a cell type =testvisible ?? Regards D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visible Row?
Hi Darin
choose in the workbook tools / macro / macros and click on testvisible and choose run - a message box will be displayed. I understood that you wanted to use this test inside some code you already had ... rather than in a cell ... did i misunderstand? Cheers julieD "Darin Kramer" wrote in message ... Howdie... Thanks... I put it into a VBA module, but where do I see the result....? In a cell type =testvisible ?? Regards D *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) | |||
Toggle text to be visible and not visible | Excel Programming | |||
Toggle Text to be visible and Not visible | Excel Programming | |||
Toggle Text in a column to be visible or not visible | Excel Programming | |||
Help: Copying Visible Cells only to Visible cells! | Excel Programming |