How do you protect a worksheet, so that users cannot change the column width or font but they can enter text into the cells and add or delete rows?
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 09/12/2007 Grade: A Views: 0
I recently worked a problem where some of my users began experiencing difficulties opening .xlsx files while using the Office 2003 Suite with the Compatibility pack installed on their machines. Fo...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am new to VBA programming and am having an issue attempting to dynamically name a range. A simplified version of the problem code is illustrated below:
Sub NameaRange()
Dim ulr As Integer...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
using office 2003 prof and excel 2003 to generate xls data and graphs sheets which is sent to colleague using office 2007. All looks ok when forwarded in 2003 format but when viewed by colleague an...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 08/26/2007 Grade: B Views: 55
We have an internal certificate server, and I have issued certificates to certain individuals for signing macros in Excel workbooks. We initiated this to avoid the "macro prompt" when opening a tr...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/08/2007 Grade: A Views: 0
Another Q if I can..
How can I counta a column where another column's cell = "London"?
For Example: CountA in Completed Clients G2:G338 where E2:E338 = "London"
So if G5 for example had some...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 10/25/2007 Grade: A Views: 0
I have an excel spreadsheet that has a list of 6719 Policy numbers that are split by agency code i.e.
Agency Policy No Policy Sort field
SWI100 ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Hi Experts,
I have a procedure working well in Excel 2003 that modifies the Button to toggle it's pressed state as part of it's functionality but the same code doesn't execute in 2007, instead r...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
Zones:
MS ExcelDate Answered: 01/10/2008 Grade: A Views: 0
If I have 2 sheets set up in my spreadsheet.
Sheet 1 has a cell where the user can enter a price of a product and cell with a drop down menu oto select todays date.
Sheet 2 records the price whe...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
I am generating a simple plot using VBA and have used the same VBA code (see below) in Excel 2003 without issue in Excel 2007 I recieve the following error Run Time Error -2147467259 (80004005) Met...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel...
