Save with Hidden Attribute ON (Excel 2000 VB)

Topic

New Reply

I have been looking all over for a way to keep the hidden attribute on when saving edited files. FYI, the files are hidden and opened through an index, but lose the hidden attribute when edited and saved. Anyone know a VB snippet that will enforce the Hidden attribute? I found this one:
Sub HideAndSave()
1 Set Newbook = Workbooks.Add
2 Newbook.Activate
3 DoSomething
4 ActiveWindow.Visible = False
5 Newbook.SaveAs filename:=”defaultstuff.xls”
End Sub
…but do not want all of this functionality. If this is close can someone advise the edits for me? THANKS!

Reply | Quote

Replies

If you are trying to make a Hidden in excel you must do as you describe set the visible property to false. SInce this properly is saved with the file, I assume you are making it visible after you open it so you can work with it.

If you mean the “hidden attribute” in windows you can use something like this line in code (after you have saved and closed the file):

SetAttr "h:hideme.xls", vbHidden

To set the properties of the file to hidden

Steve

Reply | Quote

If you are trying to make a Hidden in excel you must do as you describe set the visible property to false. SInce this properly is saved with the file, I assume you are making it visible after you open it so you can work with it.

If you mean the “hidden attribute” in windows you can use something like this line in code (after you have saved and closed the file):

SetAttr "h:hideme.xls", vbHidden

To set the properties of the file to hidden

Steve

Reply | Quote