I created documents in Excel and now they are all shown with restricted permission.
I don't know how it this happened how can I get rid of this.
Can I have an idea how can I block a cell of entering data unless another
cell have data fist
Cell D:5 must not accept data
Unless B:2 have a data
if cell B:2 is blank no entry can be done in cell D:5
I must enter data in B:2 first
I am trying to write a custom data validation for cells with data
validation values: The cell content in column A is restricted to
values 1 and 2. The cell content in Column B is restricted to values 1, 2, 3, 4, 98, or 97. Value 97 in column B is only suppose to be used when the value in Column A is 2, so I would like to have a warning sign when a value other than 97 is entered in Column B when the value in Column A is 2. I input this formula in the data validation custom field: =AND(A1=2,B2<>97) and tested it by entering 2 in column A and 4 in Column B and no warning message appeared. Is there another
formula that should be used when attempting a custom data validation on cells with data validation values.
We have two workbooks a timesheet and a tracking sheet placed in a network with many users. All users have their own tracking sheet and a single common timesheet placed in a access restricted folder. The problem is when a tracking sheet is linked with the timesheet it doesn't work. Can anyone help me with linking these workbooks without affecting the access rights?
I'm trying to create a new holiday spreadsheet which automatically changes linked cells to 'Restricted' when a Holiday is inserted a different cell. So for example if one person was on holiday on a given date the people that cannot have that day off are automatically shown 'restricted' in the corresponding cell.
Now this working with cells which are only looking at one other cell! But not for the 2 cells which are looking at more than one. Also some cells are looking at cells which are looking at them which is creating 'circular references'.
the formula I have in the cell which is working is :=IF(E6=R$8,"Restricted","-")
the cell which isn't working : =IF(OR(J6=R$8,I6=R$8,F6=R$8),"Restricted","-")
Is it possible to post the file for others to look at.
Thank you to all who help me because I'm at wits end.
Related Applications & Scripts
Pre Safe Brower is a simple utility which blocks unwanted, porn and restricted URLs on your local system. A kind of pc child lock,secure and password protect utility to prevent your system from bad or restricted URLs. Also you can redirect the restricted URLs to your own choice URLs. Pre Safe Browser is a very nice utility that works in stealth mode and can not be access by other pc users accept admin. Simply install and run this utility.
Catch visitors' attention with menu or other valuable content in animated floating box. Integrates with Joomla module and templating system to move other module(s) following user scrolling. Can be centered or can have distanced from any window border. Works in free-floating mode (not restricted to specific area, can overlap other page elements) or confined mode (restricted to a specific area).
F-Admin Panel is a professional flash component that allows you to set up your own flash Administration / Restricted area within minutes. Its a powerful flash-php engine that lets you add/edit users in 3 levels of access, you can change their pictures and manage information about each one of them. It has a unique stylish design and installation as easy as possible. If there is sufficient interest Im planning to do admin modules for the most wanted flashden files.
BusyBeeCart.com's shopping cart system is a feature packed shopping cart that will allow you to fully customize it to fit the look and feel of your current website. Through the use of templates, you are not restricted to the look and layout that our designers come up with. Change as little or as much as you need in order to make the cart flow easily with your site.
Flexibility & customizability is key for a successful e-commerce website. If you can not stand apart from the competition, you will not grab the customers attention and business. If your e-commerce solution forces you to use a cookie cutter design or does not allow customizations, your site will just be lost in cyberspace