Can I associate a flag /tag with an excel workbook?

[smithar]

Hi

I have a situation wherein, a particular style is applied to the excel. When the excel is opened, the program should check if a particular style has been applied to the excel, if not it has to prompt the user. Can I associate a tag or flag with a workbook?

regards,
Smitha

 

[Ivan F Moala]

On 2002-10-30 03:56, smithar wrote:
Hi

I have a situation wherein, a particular style is applied to the excel. When the excel is opened, the program should check if a particular style has been applied to the excel, if not it has to prompt the user. Can I associate a tag or flag with a workbook?

regards,
Smitha

Welcome to the Board Smithar
Just have code to check the workbooks
Style property name for your style eg

<pre/>
Sub Tester()
Dim st As Style

For Each st In ActiveWorkbook.Styles
MsgBox st.Name
Next
End Sub
</pre>