2个回答
2012-07-05 · 知道合伙人软件行家
关注
展开全部
只显示第一脊源伏个樱携工作表,其它的工作表隐裂碰藏
Private Sub Workbook_Open()
for i = 2 to sheets.count
sheets(i).visible=false
next
End Sub
指定工作表sheet1不隐藏
Private Sub Workbook_Open()
dim sh as worksheet
for each sh in worksheets
if sh.name<>"sheet1" then sh.visible=false
next
End Sub
Private Sub Workbook_Open()
for i = 2 to sheets.count
sheets(i).visible=false
next
End Sub
指定工作表sheet1不隐藏
Private Sub Workbook_Open()
dim sh as worksheet
for each sh in worksheets
if sh.name<>"sheet1" then sh.visible=false
next
End Sub
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询