Changing the File Save Properties

  • Thread starter Thread starter Kirk
  • Start date Start date
K

Kirk

Is there a way to change the file properties of a
spreadsheet? What I want to do is set a flag within the
Comments section of the File properties so that if a
certain function is performed, it'll set the flag and the
next time the spreadsheet is open that function won't
appear again.

Is that possible?

Any help would be appreciated.

Kirk
 
Kirk,

This code creates a custom property. Just tag it to your code

ActiveWorkbook.CustomDocumentProperties.Add Name:="myName", _
LinkToContent:=False, _
Type:=msoPropertyTypeString, _
Value:="Bob", _
LinkSource:=False
 
Back
Top