You cannot do either without a macro.
You have to have at least one sheet visible.
To hide or unhide all sheets you can use:
For sht = 2 to sheets.count
sheets(sht).visible = false '(or true)
next sht
To sort sheets, I would first load the sheet names into an array,
sort the array,
then turn off screen updating before moving the sheets.
like:
Option Explicit
Sub Sort_Sheets()
Dim ShtArray, inx
Dim SortFlag, tSheet
ReDim ShtArray(Sheets.Count)
For inx = 1 To Sheets.Count
ShtArray(inx) = Sheets(inx).Name
Next inx
SortFlag = True
While SortFlag
SortFlag = False
For inx = 2 To UBound(ShtArray)
If ShtArray(inx) < ShtArray(inx - 1) Then
SortFlag = True
tSheet = ShtArray(inx)
ShtArray(inx) = ShtArray(inx - 1)
ShtArray(inx - 1) = tSheet
Exit For
End If
Next inx
Wend
Application.ScreenUpdating = False
For inx = 1 To UBound(ShtArray)
Sheets(ShtArray(inx)).Move After:=Sheets(Sheets.Count)
Next inx
Application.ScreenUpdating = True
MsgBox "Sorted"
End Sub
-----------------------------------------------------------
If you want the sheets to automatically sort when they're CREATED, then you
can create a NewSheet event macro:
Private Sub Workbook_NewSheet(ByVal Sh As Object)
ActiveSheet.Name = InputBox("Enter Sheet Name", "New Sheet")
Sort_Sheets
End Sub
Hope this helps.
Paul S.
On Thursday, September 20, 2012 7:25:19 AM UTC-4, shrini wrote:
> Dear all
>
> I have 2 Queastion
>
> 1.Can I hide All the sheet in oe go.
> 2.How to arrange the sheet in Alphabatical order automatically.
>
> Thanks in advance.
>
> --
> Shrini
>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.com.
