| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
two questions, Yes/No form control, and how did they create this adjustable area on the sheet...
I see that I can instert form control/option button, but what I need is to
have a list of questions that can each be answered Yes/No Question Yes No Question Yes No Question Yes No Also I was asked to help with spreadsheet that has what appears to be a box (could be the print area) around the data. Outside of that box is sort of grayed out... I can drag the edge of the box with my mouse and it seems like it changes the print area... I have no idea how they created this area on the spearsheet Any help would be appreciated! Kelvin |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two questions, Yes/No form control, and how did they create this adjustable area on the sheet...
I figured out that the issue with the option buttons what a security/macro
not being enabled... but I havn't figure out the other question. Kelvin "Kelvin" wrote in message ... I see that I can instert form control/option button, but what I need is to have a list of questions that can each be answered Yes/No Question Yes No Question Yes No Question Yes No Also I was asked to help with spreadsheet that has what appears to be a box (could be the print area) around the data. Outside of that box is sort of grayed out... I can drag the edge of the box with my mouse and it seems like it changes the print area... I have no idea how they created this area on the spearsheet Any help would be appreciated! Kelvin |
|
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two questions, Yes/No form control, and how did they create this adjustable area on the sheet...
I believe you are talking about Page Break Preview mode. To turn this
feature on/off, go to View|Page Break Preview. This allows you to use the mouse to change where page breaks occur, not the print area. Hope that helps! "Kelvin" wrote in message ... I figured out that the issue with the option buttons what a security/macro not being enabled... but I havn't figure out the other question. Kelvin "Kelvin" wrote in message ... I see that I can instert form control/option button, but what I need is to have a list of questions that can each be answered Yes/No Question Yes No Question Yes No Question Yes No Also I was asked to help with spreadsheet that has what appears to be a box (could be the print area) around the data. Outside of that box is sort of grayed out... I can drag the edge of the box with my mouse and it seems like it changes the print area... I have no idea how they created this area on the spearsheet Any help would be appreciated! Kelvin |
|
#4
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
two questions, Yes/No form control, and how did they create this adjustable area on the sheet...
that was it!
Thanks Kelvin "M. Authement" wrote in message ... I believe you are talking about Page Break Preview mode. To turn this feature on/off, go to View|Page Break Preview. This allows you to use the mouse to change where page breaks occur, not the print area. Hope that helps! "Kelvin" wrote in message ... I figured out that the issue with the option buttons what a security/macro not being enabled... but I havn't figure out the other question. Kelvin "Kelvin" wrote in message ... I see that I can instert form control/option button, but what I need is to have a list of questions that can each be answered Yes/No Question Yes No Question Yes No Question Yes No Also I was asked to help with spreadsheet that has what appears to be a box (could be the print area) around the data. Outside of that box is sort of grayed out... I can drag the edge of the box with my mouse and it seems like it changes the print area... I have no idea how they created this area on the spearsheet Any help would be appreciated! Kelvin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible to create a dynamic range in CONTROL TOOLBOX (form) | Excel Discussion (Misc queries) | |||
| Excel 2007 vs. 2003 VBA Control Questions | Excel Discussion (Misc queries) | |||
| Can I create an entry form that will feed a data sheet | Excel Worksheet Functions | |||
| I need a form to create pay stubs from a payroll data sheet | Excel Discussion (Misc queries) | |||
| How do I create a form in a worksheet with control option buttons. | New Users to Excel | |||
![Kelvin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
