98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Unhiding sheet based on cell value
Unhiding sheet based on cell value
Resolved · Medium Priority · Version 2003
Ben has attended:
Excel VBA Intro Intermediate course
Unhiding sheet based on cell value
Hi,
I have a number of worksheets hidden, however i want to unhide the sheets if a cell (u8, on the data entry tab) value = true.
I've tried the following, but i keep getting prof1 is a invalid qualifier.
Option Explicit
Option Compare Text
Dim prof1 As String
Sub unhide()
Sheets("Data Entry").Range("u8").Text = prof1
If prof1.Value = True Then
Sheets("Profile 1 - Expo. Rating").Visible = True
Else
Sheets("Profile 1 - Expo. Rating").Visible = False
End If
End Sub
RE: Unhiding sheet based on cell value
Hi Ben
Thanks for your question
Prof, in your example is a simple string value. Thus the term prof.value has no meaning.
"If Prof = True", would be the correct construct
Regards
Stephen
Training information:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Transpose textYou can transpose any range of cells, turning the columns into rows and the rows into columns. Just follow these steps: |