Restrict users to rows

Hi

We have a requirement which is fairly complex however I am sure that it can be done.

We need to restict users to view selected rows and columns in a spreadsheet and each time that a user opens a spreadsheet it should possibly run a code and display different rows and columns depending on who is opening the spreadsheet.

We would like to capture all sales figures in one spreadsheet. Managers should be able to see all clients and all figures. Sales people should only be able to see their clients and specific figures. Is this possible?

I would really appreciate it if someone could point me in the right direction.

Thanks
Tony

It can likely be done, but you will need to provide all details and, preferrably, upload a example workbook that accurately shows your structure.

However, keep in mind that users can choose not to enable macros when the workbook opens and thereby defeat so called "security." Excel is not a secure application.

Thanks for getting back to me.

What sort of application would you recommend as an alternative?

Could provide me with a brief description of how to enable this?

Thanks Again

Thanks again

I have been out of the office and have not been able to reply.

Unfortunately the link you suggested is broken. I would really apreciate it if you could send some more info.

Thanks

I posted this question and I am still a bit unclear as to how to go about enabling this functionality.

We need to restict users to view specific cells in a spreadsheet and each time that a user opens a spreadsheet it should possibly run a code and display different cells depending on who is opening the spreadsheet.

The research I have done around this seems to indicate that perhaps I could password enable certain cells and show/hide cells depending on the password that is entered.

I would really appreciate it if someone could assist me.

Apologies for the broken link. I have now amended my earlier post and the link is working.

I have to remind you that any user can choose to not enable macros, so don't be lulled into a false sense of security about users not being able to gain access to "hidden" cells (though you can make it difficult to do so).

Hi

I attempted to access the link you suggested however it kept timing out.

I assume that this cannot be done. I will attempt to achieve in another application.

Thanks