Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controls on Sheet
Hi all, To make spreasheets professional I put some controls from
"More Controls" like for example I put "Microsoft Date and Time Picker Control" and also "Microsoft ProgressBar Control" on Sheet and it had correct width and height until I closed the workbook and when i opened it again, all the controls width and height gone funny. Please can any friend can help that how can I fix controls width and height which keeps remain even if i close the workbook and open it again. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controls on Sheet
Hi
Right click the control and choose Format, Properties. Click on "Don't move or size with cells". regards Paul On Mar 24, 3:29*pm, K wrote: Hi all, To make spreasheets professional I put some controls from "More Controls" like for example I put "Microsoft Date and Time Picker Control" and also "Microsoft ProgressBar Control" on Sheet and it had correct width and height until I closed the workbook and when i opened it again, all the controls width and height gone funny. *Please can any friend can help that how can I fix controls width and height which keeps remain even if i close the workbook and open it again. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Controls on Sheet
1. Select all controls
2. Right click and view Size and Properties 3. Within properties Tab under 'Object Positioning' change the settings. If this post helps click Yes -------------- Jacob Skaria "K" wrote: Hi all, To make spreasheets professional I put some controls from "More Controls" like for example I put "Microsoft Date and Time Picker Control" and also "Microsoft ProgressBar Control" on Sheet and it had correct width and height until I closed the workbook and when i opened it again, all the controls width and height gone funny. Please can any friend can help that how can I fix controls width and height which keeps remain even if i close the workbook and open it again. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding Sheet Controls | Excel Programming | |||
Need more than 1208 controls per sheet | Excel Discussion (Misc queries) | |||
Controls in protected sheet | Excel Programming | |||
Unable to use controls when sheet is protected | Excel Programming | |||
Counting Controls in a sheet | Excel Programming |