Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
RH
 
Posts: n/a
Default "Allow users to edit range." Office 03 vs. 97...

I am working on a project related to spreadsheet security and would like to
utilize the flexibility the "Allow users to edit ranges..." feature in Office
03 offers. Most people at the company appear to still be on office 97 (Win2k
is the OS) and this feature does not appear to work. Does anyone know if
there is anyway to use this feature in office 97, or would an upgrade be
required?
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

First of all "spredsheet security" is an oxymoron, there is no such thing,
sure you can protect against Grandma Sarah but anyone that would bother to
use a search engine will find that sheet and workbook protection is basically
non existant

With regards to your question yes your users would need an Office upgrade
for this to work. If you are developing any systems always use the oldest
version to develop in


Regards,

Peo Sjoblom

"RH" wrote:

I am working on a project related to spreadsheet security and would like to
utilize the flexibility the "Allow users to edit ranges..." feature in Office
03 offers. Most people at the company appear to still be on office 97 (Win2k
is the OS) and this feature does not appear to work. Does anyone know if
there is anyway to use this feature in office 97, or would an upgrade be
required?

  #3   Report Post  
Chip Pearson
 
Posts: n/a
Default

That feature is not available in Excel 97. Users would have to
upgrade.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"RH" wrote in message
...
I am working on a project related to spreadsheet security and
would like to
utilize the flexibility the "Allow users to edit ranges..."
feature in Office
03 offers. Most people at the company appear to still be on
office 97 (Win2k
is the OS) and this feature does not appear to work. Does
anyone know if
there is anyway to use this feature in office 97, or would an
upgrade be
required?



Reply
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
how do I make a word typed in a cell go to a specific cell in anot Lmatarazzo Excel Discussion (Misc queries) 3 April 21st 05 04:29 AM
Allow users to edit range query manxshaun Excel Discussion (Misc queries) 7 April 15th 05 11:31 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM
Define a range based on another named range Basil Excel Worksheet Functions 2 February 21st 05 01:47 PM
Multiple excel users can open the same file and edit at the same . Jeff Howard Excel Discussion (Misc queries) 1 February 18th 05 12:19 PM


All times are GMT +1. The time now is 01:27 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"