Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowModal property
I have 150 Excel Workbooks which contain form and modules.
Is there any way to change the showModal property of one of the form in all the workbooks through a vba macro. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ShowModal property
Try something like the following:
Sub AAA() Dim WB As Workbook Dim FName As String FName = Dir("C:\Temp\*.xls") ' change as required Do Until FName = "" Set WB = Workbooks.Open(FName) WB.VBProject.VBComponents("UserForm1") _ .Properties("ShowModal").Value = True ' or False WB.Save WB.Close FName = Dir() Loop End Sub Change the directory in the Dir function to your directory, and change "UserForm1" to the name of the form. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "VJ" wrote in message ... I have 150 Excel Workbooks which contain form and modules. Is there any way to change the showModal property of one of the form in all the workbooks through a vba macro. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get ShowModal property | Excel Programming | |||
Value Property vs Text property | Excel Programming | |||
UserForm - ShowModal Error | Excel Programming | |||
Runtime error 380: Could not set the List property. invalid property value of listbox | Excel Programming | |||
Is there a Filename property in PrintOut property | Excel Programming |