AOA Forums AOA Forums AOA Forums Folding For Team 45 AOA Files Home Front Page Become an AOA Subscriber! UserCP Calendar Memberlist FAQ Search Forum Home


Go Back   AOA Forums > Software > OS, Software, Firmware, and BIOS


Reply
 
LinkBack Thread Tools Rate Thread
  #1 (permalink)  
Old 17th September, 2008, 02:52 AM
Rondog's Avatar
Member
 
Join Date: January 2005
Location: Victoria, Australia
Posts: 3,298
Send a message via MSN to Rondog

Permission based MS Excel 2007 Documents

Just a quick query, is it possible to have permissions on excel documents to allow you to:

- Give an office manager read/write permission but all other staff read only
- Hide some columns of the spreadsheet so only office manager, and business owner can see it, and all other employee's can not.

The document in question is a roster/time sheet.

If not, what program do you recommend that could achieve said requirements.
__________________
AOA Team fah

Rig 1: Intel Core i5 750,4gb,HD6870,500gb,W7 Ult x64
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 17th September, 2008, 11:52 AM
Chief Systems Administrator
 
Join Date: September 2001
Location: Europe
Posts: 13,075

You should (although I've never tried) be able to use IRM (Information Rights Management) in order to achieve at least the first of these. Alternatively you could just protect a range of cells with a single password - anyone who knows the password can enter it and edit it.
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 17th September, 2008, 12:08 PM
Rondog's Avatar
Member
 
Join Date: January 2005
Location: Victoria, Australia
Posts: 3,298
Send a message via MSN to Rondog

Thanks for the info.

I don't know much about Sharepoint, but I have heard it may be suitable for what I am trying to achieve. Do you think it would work instead of Excel Áedán?
__________________
AOA Team fah

Rig 1: Intel Core i5 750,4gb,HD6870,500gb,W7 Ult x64

Last edited by Rondog; 17th September, 2008 at 12:09 PM.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 17th September, 2008, 02:55 PM
Chief Systems Administrator
 
Join Date: September 2001
Location: Europe
Posts: 13,075

To be honest, I've not had great encounters with sharepoint, so I'm probably not the best person to ask!
__________________
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 noob OS, Software, Firmware, and BIOS 7 28th September, 2007 05:51 PM
Need urgent help with excel, how to countif in Excel 2003 Rondog OS, Software, Firmware, and BIOS 2 24th September, 2007 05:28 AM
Changing Documents Defaults kellamne OS, Software, Firmware, and BIOS 16 26th March, 2006 10:44 AM
Traceable Documents? Gizmo Digital Image, Photo, Video and Audio Editing. 17 20th October, 2005 02:59 PM
Faith Based Believers vs. Reality Based Folks cloasters Betty's Rants and Rages 110 23rd December, 2004 07:27 PM


All times are GMT +1. The time now is 02:43 AM.


Copyright ©2001 - 2010, AOA Forums
Don't Click Here Don't Click Here Either

Search Engine Friendly URLs by vBSEO 3.3.0