"Pat" wrote in message
...
What change do I need to make so that the code will carry out the
following instruction

Me.CloseExcelExport.Enabled = False

it does not seem to like "Me" method.

Hi Pat,

I'm not sure exactly what the CloseExcelExport property is, but the Me
keyword can only be used inside a class module. Class modules include not
only the modules that you can add manually through the VBE, but also the
code behind modules for UserForms, Worksheets and ThisWorkbook.

Although it's probably obvious, the Me keyword can only be used to
access properties and methods of the class in which it is used. If you need
to call a property or method located in another class you'll need to use an
object reference to that class.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm