Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
Hi All,
Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
Tools/Customize/Customize Toolbars/Menus... In the dialog's Commands
pane, select Categories: All commands, then scroll down to find Camera. Drag to a toolbar of your choice. In article , nde wrote: Hi All, Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
I do not have the All Commands choice.
I went through all command menu and I am not able to find the Camera one ! Nde "JE McGimpsey" wrote: Tools/Customize/Customize Toolbars/Menus... In the dialog's Commands pane, select Categories: All commands, then scroll down to find Camera. Drag to a toolbar of your choice. In article , nde wrote: Hi All, Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
Hi,
In xl2003. Tools Customize Commands. Select the Tools category. In the Commands list is the Camera item. About 40th in the list. Cheers Andy nde wrote: I do not have the All Commands choice. I went through all command menu and I am not able to find the Camera one ! Nde "JE McGimpsey" wrote: Tools/Customize/Customize Toolbars/Menus... In the dialog's Commands pane, select Categories: All commands, then scroll down to find Camera. Drag to a toolbar of your choice. In article , nde wrote: Hi All, Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
You could open the VB editor (Alt + F11) and type this into the immediate
window: Application.CommandBars("Formatting").Controls.Add _ Type:=msoControlButton,ID:=280, Befo=1 Of course this will probably only work for xl 2003 -- Charles Chickering "A good example is twice the value of good advice." "nde" wrote: I do not have the All Commands choice. I went through all command menu and I am not able to find the Camera one ! Nde "JE McGimpsey" wrote: Tools/Customize/Customize Toolbars/Menus... In the dialog's Commands pane, select Categories: All commands, then scroll down to find Camera. Drag to a toolbar of your choice. In article , nde wrote: Hi All, Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Camera Object
Try this instead: Copy the range the regular way, hold Shift while selecting
the Edit menu, and choose Paste Picture Link. Same result, without a border around the pasted picture. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "nde" wrote in message ... Hi All, Here is a samplke of an article I found on the net: <Excel's Camera object is the key to traffic-light reporting. This tool has been a standard part of Excel for many years, but very few Excel users have ever used it. <In a new worksheet, enter text in cell B2. If you want, add some color and other formatting as shown. Then select cell B2 and click on the Camera icon. When you do so, the border around cell B2 turns into a moving marquee, and your mouse pointer turns into a cross. Now click anywhere on your spreadsheet. When you do so, Excel returns the Camera object, as shown in the illustration above. You can move this object anywhere on your worksheet. Though I am not able to find the Icon, anyone knows where to find it, looks like a nice feature ! Thanks, Nde |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make camera object refer to dynamic range | Excel Discussion (Misc queries) | |||
Camera Object - how to set default Fill = Transparent | Excel Discussion (Misc queries) | |||
Camera in Excel 2007 | Charts and Charting in Excel | |||
Camera Object | Excel Discussion (Misc queries) | |||
I am trying to use the "Camera" function within Excel | Excel Worksheet Functions |