98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » VBA
VBA
Resolved · Medium Priority · Version 2003
Thu 13 Aug 2009, 16:59Delegate Trevor said...
Trevor has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Access Intermediate course
Excel VBA Advanced course
VBA
Help!
Have used the two simplest macros below a lot and now one will not work. I cannot get the two worksheets back using "un hidden" - they are both there as cannot duplicate names for new sheets and can see them in VB editor. Any advice - thanks !
Trevor
Sub Very_Hidden()
Sheets("Intercompany").Visible = xlVeryHidden
Sheets("Lookups").Visible = xlVeryHidden
End Sub
Sub Un_Hidden()
Sheets("Intercompany").Visible = xlVeryHidden
Sheets("Lookups").Visible = xlVeryHidden
End Sub
Mon 17 Aug 2009, 09:31Trainer Stephen said...
RE: VBA
hi Trevor
Thanks for your question
This is hard to answer without seeing the workbook in question
Could you email me a copy so that I can give your question more detailed attention
my email is stephen@stl-training.co.uk
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. |
VBA tip:Empty The Clipboard with CutCopyModeAfter each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload: |
