LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Spinners and protected sheets

Excel 2003

I made a beautiful spreadsheet doing some calculations for real estate
finance and went to protect it so users can not inadvertently alter it.
However, my spinners are not working as I believe they should.

I have a spinner used to vary the interest rate from 2% to 13%. I used a
proxy cell (A1) and divided by 10000 to enable the rate to adjust in .25%
increments. The cell plugs in at B1 (=A1/10000). Cell B1 reminds me it's a
formula and to protect it. The Spinner seems to have a unlocked status
seperate to cell B1, which I want the user to use, but when sheet is
protected I can't change the spinner??? that can't be right?

Thanks in advance!
 
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
Protected Sheets Jeanne724 Excel Discussion (Misc queries) 2 March 18th 08 06:37 PM
protected sheets Jock Excel Worksheet Functions 3 December 4th 07 12:51 PM
protected sheets Aspen Excel Discussion (Misc queries) 1 November 11th 06 08:05 PM
Spinners Brad Excel Discussion (Misc queries) 7 September 13th 06 06:55 PM
Spinners - minimum and maximum Brad Excel Discussion (Misc queries) 2 September 11th 06 03:33 PM


All times are GMT +1. The time now is 04:51 PM.

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

About Us

"It's about Microsoft Excel"