I have found the following instructions on the MS online help but it is a
little over my head. I have two questions that I need to ask to get started
and then I can fumble though the rest. First, I do not understand step !.
What does it mean to insert a new module? Second, In step 2 where is the
menu editor command? I don't see it under tools in Excel.

1. Insert a new module in a workbook.
2. To add a command called "Database" below the Toolbars command on the View
menu, choose the Menu Editor command from the Tools menu.

For more information about using the Menu Editor, see pages 242-244 of the
"Visual Basic User's Guide."
3. Select a portion of the worksheet that you want to be the database view
and give it the assigned name "Database_View." Repeat this procedure for the
worksheet view, and give that worksheet selection the defined name
"Worksheet_View."
4. Switch to the Visual Basic module, and enter the following code:
Sub DatabaseView()
With MenuBars(xlWorksheet).Menus("View").MenuItems("Dat abase")
.Checked = Not .Checked 'toggles check mark on/off
If .Checked Then
'Switch to Database View
Application.Goto "Database_View", True
Else
'Switch to Worksheet View
Application.Goto "Worksheet_View", True
End If
End With
End Sub


5. Using the Menu Editor, assign the DatabaseView macro to the Database
command.
6. Activate the worksheet.
7. Choose Database from the View menu.

That is for Excel 5/95. What version of Excel are you using. there is no
menu editor in Excel 97 and later.

What are you trying to do?

http://support.microsoft.com/default...b;en-us;830502
How to customize menus and menu bars in Excel

Look about half way down the page for the answer to your question.

--
Regards,
Tom Ogilvy


"TimlmiT" wrote in message
...
I have found the following instructions on the MS online help but it is a
little over my head. I have two questions that I need to ask to get
started
and then I can fumble though the rest. First, I do not understand step !.
What does it mean to insert a new module? Second, In step 2 where is the
menu editor command? I don't see it under tools in Excel.

1. Insert a new module in a workbook.
2. To add a command called "Database" below the Toolbars command on the
View
menu, choose the Menu Editor command from the Tools menu.

For more information about using the Menu Editor, see pages 242-244 of the
"Visual Basic User's Guide."
3. Select a portion of the worksheet that you want to be the database view
and give it the assigned name "Database_View." Repeat this procedure for
the
worksheet view, and give that worksheet selection the defined name
"Worksheet_View."
4. Switch to the Visual Basic module, and enter the following code:
Sub DatabaseView()
With MenuBars(xlWorksheet).Menus("View").MenuItems("Dat abase")
.Checked = Not .Checked 'toggles check mark on/off
If .Checked Then
'Switch to Database View
Application.Goto "Database_View", True
Else
'Switch to Worksheet View
Application.Goto "Worksheet_View", True
End If
End With
End Sub


5. Using the Menu Editor, assign the DatabaseView macro to the Database
command.
6. Activate the worksheet.
7. Choose Database from the View menu.

I want a cell in my Excel file to show a check mark or no chack mark when I
click on it. As of now, it is using a list to provide those optons but I just
want to click on the cell once to give me a check or no check. How do I do
this? I am running Excel 2003 (XP version).

TIA,
Tim

"Tom Ogilvy" wrote:

That is for Excel 5/95. What version of Excel are you using. there is no
menu editor in Excel 97 and later.

What are you trying to do?

http://support.microsoft.com/default...b;en-us;830502
How to customize menus and menu bars in Excel

Look about half way down the page for the answer to your question.

--
Regards,
Tom Ogilvy


"TimlmiT" wrote in message
...
I have found the following instructions on the MS online help but it is a
little over my head. I have two questions that I need to ask to get
started
and then I can fumble though the rest. First, I do not understand step !.
What does it mean to insert a new module? Second, In step 2 where is the
menu editor command? I don't see it under tools in Excel.

1. Insert a new module in a workbook.
2. To add a command called "Database" below the Toolbars command on the
View
menu, choose the Menu Editor command from the Tools menu.

For more information about using the Menu Editor, see pages 242-244 of the
"Visual Basic User's Guide."
3. Select a portion of the worksheet that you want to be the database view
and give it the assigned name "Database_View." Repeat this procedure for
the
worksheet view, and give that worksheet selection the defined name
"Worksheet_View."
4. Switch to the Visual Basic module, and enter the following code:
Sub DatabaseView()
With MenuBars(xlWorksheet).Menus("View").MenuItems("Dat abase")
.Checked = Not .Checked 'toggles check mark on/off
If .Checked Then
'Switch to Database View
Application.Goto "Database_View", True
Else
'Switch to Worksheet View
Application.Goto "Worksheet_View", True
End If
End With
End Sub


5. Using the Menu Editor, assign the DatabaseView macro to the Database
command.
6. Activate the worksheet.
7. Choose Database from the View menu.

Tim,

Let's say that you want your check marks in column "A"
Set column A font to Webdings

Put this code in the worksheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 Then
If Len(Target) 0 Then
Target.ClearContents ' or Target = ""
Else: Target = "a"
End If
End If
End Sub

[ This works in Excel 2000 ]

--
steveB

Remove "AYN" from email to respond
"TimlmiT" wrote in message
...
I want a cell in my Excel file to show a check mark or no chack mark when I
click on it. As of now, it is using a list to provide those optons but I
just
want to click on the cell once to give me a check or no check. How do I do
this? I am running Excel 2003 (XP version).

TIA,
Tim

"Tom Ogilvy" wrote:

That is for Excel 5/95. What version of Excel are you using. there is
no
menu editor in Excel 97 and later.

What are you trying to do?

http://support.microsoft.com/default...b;en-us;830502
How to customize menus and menu bars in Excel

Look about half way down the page for the answer to your question.

--
Regards,
Tom Ogilvy


"TimlmiT" wrote in message
...
I have found the following instructions on the MS online help but it is
a
little over my head. I have two questions that I need to ask to get
started
and then I can fumble though the rest. First, I do not understand step
!.
What does it mean to insert a new module? Second, In step 2 where is
the
menu editor command? I don't see it under tools in Excel.

1. Insert a new module in a workbook.
2. To add a command called "Database" below the Toolbars command on the
View
menu, choose the Menu Editor command from the Tools menu.

For more information about using the Menu Editor, see pages 242-244 of
the
"Visual Basic User's Guide."
3. Select a portion of the worksheet that you want to be the database
view
and give it the assigned name "Database_View." Repeat this procedure
for
the
worksheet view, and give that worksheet selection the defined name
"Worksheet_View."
4. Switch to the Visual Basic module, and enter the following code:
Sub DatabaseView()
With
MenuBars(xlWorksheet).Menus("View").MenuItems("Dat abase")
.Checked = Not .Checked 'toggles check mark on/off
If .Checked Then
'Switch to Database View
Application.Goto "Database_View", True
Else
'Switch to Worksheet View
Application.Goto "Worksheet_View", True
End If
End With
End Sub


5. Using the Menu Editor, assign the DatabaseView macro to the Database
command.
6. Activate the worksheet.
7. Choose Database from the View menu.

Good evening TimImiT

You need to use either the Forms toolbar or the Control Toolbox
toolbar. Both have a check box option. The Forms toolbar is better
for beginners, the Control Toolbox toolbar offers more in terms of
degrees of control, but is trickier to get to grips with.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=376825