Unhiding All hidden Worksheets with a Macro/VBA Code

Hi,

Can anyone help me please ?

Whilst working with an Excel Workbook  I often hide all unwanted
Worksheets leaving only the ones I need to work on visible. 

What I would like to do is have a macro or VBA code to click on a
button to unhide all hidden worksheets rather repeating
Format-Sheet-Unhide to unhide each worksheet.

Any help would be greatly appreciated (Excel version Excel 2000)


Many thanks

Rob


-- 
robertguy

44 Married two kids
------------------------------------------------------------------------
robertguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5963
View this thread: http://www.excelforum.com/showthread.php?threadid=490133

0
12/2/2005 1:20:18 PM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
315 Views

Similar Articles

[PageSpeed] 0

Try this

    Dim mySheet As Worksheet
    For Each mySheet In Worksheets
        mySheet.Visible = True
    Next mySheet


"robertguy" wrote:

> 
> Hi,
> 
> Can anyone help me please ?
> 
> Whilst working with an Excel Workbook  I often hide all unwanted
> Worksheets leaving only the ones I need to work on visible. 
> 
> What I would like to do is have a macro or VBA code to click on a
> button to unhide all hidden worksheets rather repeating
> Format-Sheet-Unhide to unhide each worksheet.
> 
> Any help would be greatly appreciated (Excel version Excel 2000)
> 
> 
> Many thanks
> 
> Rob
> 
> 
> -- 
> robertguy
> 
> 44 Married two kids
> ------------------------------------------------------------------------
> robertguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5963
> View this thread: http://www.excelforum.com/showthread.php?threadid=490133
> 
> 
0
bigwheel926 (227)
12/2/2005 1:42:04 PM
It Works

Many thanks to bigwheel !!

Rob


-- 
robertguy

44 Married two kids
------------------------------------------------------------------------
robertguy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=5963
View this thread: http://www.excelforum.com/showthread.php?threadid=490133

0
12/2/2005 3:10:16 PM
Reply:

Similar Artilces:

disable unhide sheets on toolbar
Hello is there a way to dis-able the unhide sheets toolbar? TIA, Ditchy Hi Ditchy Protect the workbook (Tools > Protection menu) to prevent hiding, unhiding and renaming of sheets. HTH. Best wishes Harald "ditchy" <ditchy@ncable.net.au> skrev i melding news:1115110468.548181.247220@g14g2000cwa.googlegroups.com... > Hello > is there a way to dis-able the unhide sheets toolbar? > TIA, Ditchy > If you want to take out that control then use Application.CommandBars("Worksheet Menu Bar").Controls("Format").Controls("Sheet").Co...

spell check does not visually cycle through cells when run from macro?
I'm trying to recreate the same behavior in a macro that spellcheck has when the spellcheck button is pressed. The spellcheck does not cycle through the cells visually when run from a macro, so when there is a misspelled word, you cannot see the cell it is a part of. If anyone knows how I can get this behavior to work, it would be GREATLY appreciated. I did a record new macro, and got code similar to the following: Sub testSpelling() Range("F2:F500").Select Selection.CheckSpelling SpellLang:=1033 End Sub thanks, dan Dan, Add the fiollowing to your code as shown: ...

Amazing Problem in AllocPhysMem wince 6.0
Hi I am writing a Port Driver for x86 platform in WinCE 6.0. I want to allocate virtual and equivalent physical memory in driver and mapped it to USER mode to use application. For that I used AllocPhysMem in driver and passed that address through IOCTL calls but i cant use that virtual and physical address in application side. Because AllocPhysMem returns Error Code as 0x57 (meaning Parameter incorrect). But the same code is working in WinCe 5.0. My code snippet is, VirAddress = (LPVOID)AllocPhysMem(32, PAGE_READWRITE|PAGE_NOCACHE, 0, ...

Setting directory for file save in macro
Hi Thanks to a generous poster I now have a great bit of code to use in a macro for Excel which saves a text file (I'm no VBA programmer so this was really helpful), i.e.: Open "Test.txt" For Output As #1 (rest of code) My problem now is this: The macro saves test.txt to Excel's current active folder, rather than the folder that the current workbook is contained in. For example, if I last saved an Excel workbook to c:\workbooks\, and the workbook that I have open exists in c:\workbooks\workbook1\, when I run the macro it saves the text file in c:\workbooks\. If I ...

Help revising slow code
I am using the following code to remove all the lines in a worksheet that have a zero value in Column H. Because there are thousands of rows in the worksheet, this loop takes forever! Does anyone have any suggestions for doing this more quickly? Thanks! Sub Delete_Row_w0() Dim Firstrow As Long Dim LastRow As Long Dim Lrow As Long Dim CalcMode As Long Dim ViewMode As Long With Application CalcMode = .Calculation .Calculation = xlCalculationManual .ScreenUpdating = False End With With Sheets(1) .Select ...

Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to only make certain rows visible based on the Machine Model that they choose. I digital signed the Worksheets and exported the Digital Signature Certificate and installed it on the User’s PCs. The code works great. The user opens the Workbook and it runs the Macros with no problem. The problem I have is when the user goes to save the Workbook. They get an error that “Excel can not sign VBA macros when saving to this file format. Do you want to remove the digital signature and continue saving this workbook?”...

Outlook
Is there a way of stopping OL from destroying HTML code when forwarding HTML formatted emails ... it seems to be very, very aggressive and eats any formatted mail that I attempt to send, it inserts <p> tags every where - I've even seen it change the height and width attributes of <img> tags etc. etc. This hasn't anything to do with my local settings - I've tried every possible combination and permutation of every check box and select box there is to be found - all to no avail - we've been able to consistently reproduce this issue on both sides of the world on many, ...

Macro Copy and Paste
I am currently trying to copy from one workbook that has 7 differen tabs and paste into one worksheet on a separate master workbook. M problem is that when I set up the macro to copy from one of the tabs i the workbook and paste to the other work book, I only want the the row to come in where there is data. Currently I am having to run a macr that takes every 100 lines, but ideally I only want the informatio copy and pasted where there is only data. In addition, once I have copy and pasted everything from the first tab my next step is to copy and paste information from the second tab t th...

Referring to a FileName in Macro
I have a Macro with the following code Application.Run "TestQry!Macro2" Application.Run "TestQry!Macro1" TestQry is the name of the file. Is there anyway that this macro cod can refer to the activeWorkbook or filename so that if the file i saved to a new name this macro will still ru -- Message posted from http://www.ExcelForum.com How about just: macro2 or even call macro2 "DoctorV <" wrote: > > I have a Macro with the following code > > Application.Run "TestQry!Macro2" > Application.Run "TestQry!Macro1" > &g...

Macro Question #10
Hi, I am working with a text file that I imported into Excel. It is a transactional report of sales by customer. The data will have the customer number and name spread out over three cells. What I want to do is to create a macro that will contatenate all three cell and then perform a paste special and paste them into another cell in another column. Since the number of transactions by customer can vary the customer name and number can appear anywhere on the page. I created a macro to do this using the first customer which appears in cell B5 through D5. The next customer appears...

Can you record a macro in Publisher like you can in Excel?
In Excel I use the feature to Record a Macro. Excel records the keystrokes and converts to VB. Does Publisher have that option? In my version, Publisher 2003, I can Create a Macro, and it takes me into VB. However, I don't know how to code VB. Darlene wrote: > In Excel I use the feature to Record a Macro. Excel records the keystrokes > and converts to VB. Does Publisher have that option? In my version, > Publisher 2003, I can Create a Macro, and it takes me into VB. However, I > don't know how to code VB. Publisher does not have a Macro Recorder, sorry. --...

Setting up Exchange 2003
I had this problem the other day while extending the schema in preparation for an upgrade to Exchange 2003. I searched through a lot of databases and search engines, and found that a lot of people have had this problem, but none of the forums led to a clear cut answer to the issue. So, I thought I'd share my solution to try and help others out, and save them some time and frustration. I was ready to call Microsoft support right before I figured this out. While running forest prep (setup /forestprep), setup failed with Error code 0XC103798A. It then specified to check the Exchange inst...

Multi-Select Listbox VBA code causing overflow in loop
Private Sub Form_Current() Dim oItem1 As Variant Dim oItem2 As Variant Dim bFound1 As Boolean Dim bFound2 As Boolean Dim sTemp1 As String Dim sTemp2 As String Dim sValue1 As String Dim sValue2 As String Dim sChar1 As String Dim sChar2 As String Dim iCount1 As Integer Dim iCount2 As Integer Dim iListItemsCount1 As Integer Dim iListItemsCount2 As Integer sTemp1 = Nz(Me!SignsList.Value, " ") sTemp2 = Nz(Me!SymptomsList.Value, " ") iListItemsCount1 = 0 iListItemsCount2 = 0 bFound1 = False bFound2 ...

Best C# Book for VBA Programmers
I have been developing in Excel/VBA/SQL for 10+ years and have a little VB.NET. I have a pretty good - but certainly not great - understanding of OOD & OOP. I want to get into C# as more and more Jobs that I'm interested in are looking for +/or expecting it but I have zero knowledge of C of any flavour. Given my background I would value all your thoughts on which is the best book(s) to buy. Or are there some ace WebSites / Parts of MSDN that I could use to achieve the same end? Thanks in advance Chris I would reccomend learning a non-microsoft language. Microsoft has proven time...

Generating Code...
Recently I have encountered what appears to be an endless hangup, tying up 100% of the cpu. Could someone explain what is going on here? ThePlanner3.cpp Generating Code... cl.exe terminated at user request. Tool execution canceled by user. I might add that this is still occurring after resetting my Release Project Settings. The Debug configuration is fine. ----------- "SteveR" <srussell@removethisinnernet.net> wrote in message news:udziG18cHHA.2316@TK2MSFTNGP04.phx.gbl... > Recently I have encountered what appears to be an endless hangup, tying up > 100% of th...

Spreadsheet macro stopped working!
Hi, I recently made an Excel spreadsheet for keeping track of my golf score. The spreadsheet is quite simple. It consists of 4 sheets: Scorecard, statistics, database and equations (for calculating some specific). I insert informations about the golf course I'm playing and how my score was etc. I then hit a button "Save scorecard" that runs a macro. The macro inserts specifik values from the scorecard into the database sheet (which works like a charm). The macro also updates the "Statistics" sheet with information about stroke number and points for ...

Hidden Outlook Directory
Outlook appears to have a hidden directory where it stores/places attachments which you have opened from within an email. The path is C:\Documents and Settings\Admin\Local Settings\Temporary Internet Files>. The hidden directory, on my pc, is called OLK22A. Problem with the directory is that I can only see it/get to it via a dos window. It doesn't show up in Windows Explorer even though I indicated that I wanted Explorer to show all hidden files and directories. How can I unhide this directory? I don't like having things sit on my harddrive that I don't want and/o...

Excel 2007 macro compatability
I have created a macro in Excel 2007 that includes importing a text file. It works fine on my PC, but fails on a co-workers PC running Excel 2000. The failure points to the "TextFile Platform" command in the macro. I have tried several (437, 1252, 20127), but get the same results. Any solution? Thanks you. Have you try xlWindows -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Al @ Frontier" <Al @ Frontier@discussions.microsoft.com> wrote in message news:3F601F80-F099-42C8-AA18-6D31A85946F9@microsoft.com... >I have cr...

Help Locking Worksheet
I inherited a workbook that has several sheets, have gone thru and mad changes and now when I lock it I cannot go from the last table cell o the first row to the second row. Tabbing will just continue you out o the same row. I want to be on cell BD3, hit tab and go to C5. Does the fact that I have the to & leftmost cells frozen have anythin to do with this? How can I fix it -- jlabshe ----------------------------------------------------------------------- jlabsher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556 View this thread: http://www.excelfo...

Printing a worksheet on 11x17 paper
I want to print a worksheet on 11x17 paper. When I try to change to that paper size in print options, there is no size like that available. What do I do??? thank you for your help in this matter. Katie It's the printer that decides that.. Do you have that option on the printer it should be available in Excel -- Regards, Peo Sjoblom "Katie" <anonymous@discussions.microsoft.com> wrote in message news:9fca01c4345c$bcdca970$a301280a@phx.gbl... > I want to print a worksheet on 11x17 paper. When I try > to change to that paper size in print options, there is ...

how do I prevent a worksheet from being copied in excel
yet allow users to select values in a defined range Good evening kensanjose You really need to supply more information about what you mean - cop the file/sheets/ranges etc Dominic -- dominic ----------------------------------------------------------------------- dominicb's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1893 View this thread: http://www.excelforum.com/showthread.php?threadid=38531 How do I prevent a worksheet from being copied in excel? Can I disable right click within a file so that the sheet cannot be copied into another file and manipula...

Excel E-mail Macros
I need to know how to create a macro that will send an excel file as an attachment to one individual, and then send one of the file's worksheets to 3 e-mail addresses using the mail recipient method so that the worksheet appears in the body of the e-mail. The e-mail program I am using is Outlook. Any help with this will be GREATLY appreciatd. Hi John, I'd tell you, but Ron de Bruin already did all the work. It'd be silly for me to do it again...Try Ron's site: http://www.rondebruin.nl/sendmail.htm tim "John" <jbegley@dcas.nyc.gov> wrote in message ne...

error code 0x800703EE
I received error code 0x800703EE when trying to install SP2 for vista-32bit OS. any help with this error code would be appreciated. Hello Jimmy, 0x800703EE ERROR_FILE_INVALID System could not allocate the required space in a registry log; The volume for a file has been externally altered so that the opened file is no longer valid. How to obtain the latest version of the Windows Update Agent [v7.4.7600.226] to help manage updates on a computer: http://support.microsoft.com/kb/949104/ I'm suяe someone else will help you if this suggestion doesn't help. ...

Blocking Old SKU or PLU code?
I have ran into a problem in blocking Old SKU's or PLU's code in our database that the Director of Retail has express interest in having them removed from the system. I the worksheet 250 - Update Inventory Items, which work fine on all stores we open in the last 2 years, but all other stores has "An Error occured while attempting to process the worksheet." I know from the list if items to be blocked that some have been blocked by management in the past and later turn back on using SQL database to make the item show up in RMS again. I am thinking this is where my pr...

format macro
Last week, Art was trying to help me with this, but the solution doesn't work for me. I'm looking for a macro that would be contained within my personal.xls, that I could use as needed. Lets say I have A1:C5 selected, which represent headdings and data for jan, feb and march. [On a different spreadsheet, it may be different columns, or a different number of columns. The point is that I will select the range before I run the macro.] I want to do an auto fit for each column, so that the column widths are big enough to fit the numbers. No problem, format-->column-->autof...