Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Ooops
I left an errant line in the code. Sorry about that. Sub Testopen() Dim ws As Worksheet Dim result As String FName = "C:\open.xls" Set oldbk = Workbooks.Open(Filename:=FName) result = "" For Each ws In Worksheets result = result & ws.Name & " is " _ & IIf(ws.ProtectContents, "protected", "unprotected") & vbCr Next ws MsgBox result oldbk.Close savechanges:=False End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Code to change code in a sheet and workbook module | Excel Programming | |||
copy and paste using code from workbook to workbook | Excel Discussion (Misc queries) | |||
run code on opening workbook and apply code to certain sheets | Excel Programming | |||
Code in one workbook to call code in another XL file | Excel Programming | |||
Reference code in another workbook from a calling workbook | Excel Programming |