Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can't Exit Design Mode because Control can not be Created

I have a simple spreadsheet that contains a number of check boxes. When I
open the file, I get the following message:

Microsoft Visual Basic
Can't exit design mode because Control "AfterCheckingValidations"
can not be created.

I had a control by that name, but I deleted it and I still get the error.
There are no conflicting names (i.e. A control with the same name as a
variable). There are no controls by that name in any of the other open
projects. Below are the only 4 sections of code that contain a name even
close to the control name given by the error message (Lines beginning with *
are for your reference, and are not actually a part of the code).

Dim cbValue As Boolean

* This is the click event of a "Check All" button on the sheet.
Private Sub cmdCheckCategoryAfter_Click()
cbValue = True
AfterCheckingValidationsTasks
End Sub

* This is the click event of a "Clear All" button on the sheet.
Private Sub cmdClearCategoryAfter_Click()
cbValue = False
AfterCheckingValidationsTasks
End Sub

* This routine is called by the click events of two buttons on the sheet.
Private Sub AllTasks()
MTRecordsTasks
NCICRecordsTasks
PrintLabelsTasks
CertDocsTasks
AfterCheckingValidationsTasks
StuffEnvelopesTasks
MailingValidationsTasks
End Sub

* This routine checks or clears the check box, depending on the state of
cbValue, which is set above depending on the button clicked.
Private Sub AfterCheckingValidationsTasks()
TrashOldCertDocs.Value = cbValue
End Sub

FYI: The last routine will eventually have more check boxes, which is what
makes the Check All and Clear All buttons advantageous to have.

Any ideas as to what is causing this error, and how to fix it?

--Tom


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel 2003: Cant exit design mode, whats the fix? Miker New Users to Excel 0 May 4th 09 11:51 PM
Can't exit Design mode because control 'SignCal' can not be created...? VB Andrew[_8_] Excel Discussion (Misc queries) 0 November 26th 08 03:34 PM
run procedure when exit design mode Wim SKW Excel Discussion (Misc queries) 1 July 11th 07 09:24 AM
I can't exit from Design mode anymore Ray Excel Discussion (Misc queries) 0 April 20th 06 02:31 PM
Enter Excel Design Mode and Exit Design Mode Bill Lunney Excel Programming 0 August 4th 03 07:48 AM


All times are GMT +1. The time now is 09:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"