Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Unhiding sheet based on cell value
|
|
|
The UK's most regular 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. |
Unhiding sheet based on cell value
Resolved · Medium Priority · Version 2003
Reply Thu 14 Apr 2011, 17:14Delegate Ben said...
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
For upcoming training course dates see: Pricing & availability
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
|