Questions

1 answer

How to password protect a folder in Microsoft Office 2003

I need to password protect an entire "FOLDER in Microsoft Office 2003. I am also on a network, using a Buffallo drive, back up system, trash flies adn want to make sure all content filex in this folder as password protected etc. I am using Windows…

asked

Anonymous

edited an answer

Anonymous

11 answers

How do I bold a word or date in a formula

Hi, I need to bold a word in a paragraph in excel. There is a reference to the cell in the paragraph but it is not formatting the information the same as the cell when it goes into the paragraph. Examples below. This Order Form is valid only for…

asked

Anonymous

edited an answer

Anonymous

39 answers

insert row in protected sheet by keeping formula

Hi I have a protected sheet contain formula in each row depends to above row( for example C2=C1+1; C3=C2+1;...).and cells contained these formula are locked. I like to allow users to insert row everywhere by keeping formula without unprotecting the…

asked

Anonymous

edited an answer

Anonymous

1 answer

Macro to save as read only

Can anyone help me with a macro that will save a worksheet as a read only with a password to open (editable)? Thanks

asked

Anonymous

edited an answer

Anonymous

0 answers

Office Add In Single Sign on - Access token Expiry

I have a word addin which uses Office.auth.getAccessToken for authenticating with azure. Does this access token has an expiry defined ? I could not see any expiry key on the response from getAccessToken().

asked

Dhiluraj V 26

0 answers

Macro - Query MySQL Database with DSN-less Connection

Can anyone help me with writing a macro to query a MySQL database? From Excel? I can successfully query the remote MySQL db using MS Query and a DSN. But I need to make it more portable, so multiple users can grab the file and work on it anywhere. I…

asked

Anonymous

1 answer

VBA, ODBC Authentication, and Passthroughs

My company is in the process of meeting certain guidelines to make steps toward going public. One of those steps involves analysts to have to change their ODBC passwords every 30 days. Not awful for adhoc type deals, but I have a reporting box that…

asked

Anonymous

edited an answer

Anonymous

4 answers

You cannot use this command on a protected sheet.

I have created a worksheet in which I've group certain rows. When I protect the sheet, the group function is no longer useable, I get the following error message: "You cannot use this command on a protected sheet. To use this command, you must first…

asked

Anonymous

edited an answer

Anonymous

3 answers

Can I allow macros to run on a protected sheet?

Maybe the answer is a simple no, but I figured I'd ask. I just want to run a simple macro that performs a filter function so I can hide the filter arrows and simplify the filtering. When I try to run the macro while the sheet is protected, I get the…

asked

Anonymous

edited an answer

Anonymous

14 answers

Insert row in a table on protected worksheet

Excel 2007 tables have this feature to add row by pressing the keyboard tab on last cell of last row. But if the workbook is protected the error message is displayed saying "cannot use this table feature with protected worksheets". I want to…

asked

Anonymous

edited an answer

Anonymous

0 answers

COnverting multiple pages in a single Word document to individual pages

I have a Word document that contains 12 seperate job descriptions, each is a seperate page within the document. Is there a quick way to save each page as it's own document??

asked

Anonymous

2 answers

Downloadable Send to OneNote 2007 Print Driver for 64-bit System?

I purchased MS OFfice Home and Student 2007 in 2007 specifically because it had OneNote (which I use to send program files as well as Internet pages to in order to save, organize and print). Recently my HP Vista laptop died the blue-screen-of-death. …

asked

Anonymous

edited an answer

Anonymous

2 answers

Images, compression, & file size

Hi Folks, I have an Excel file I am working on with an image box that has click event code to insert a picture. I've been trying to include code to automatically compress the image. The file size gets huge. The file size is 48 kb, if I insert a 5.0 MB…

asked

Anonymous

edited an answer

Anonymous

3 answers

How to allow 'Group/Ungroup' on a Protected and Locked Worksheet

Right, this may be structures and security so lets try... I have a pretty big Excel Progress Claim workbook, that is 'organised' with worksheets (tabs) like below: Actual Claim summary, working over 968 lines for the Project work items Several tabs…

asked

Anonymous

edited an answer

Anonymous

24 answers

Expanding/Collapsing Grouped Columns/Rows When a Sheet is Protected

I want to protect the locked cells in any given spreadsheet so that the user cannot override formula cells. I have also grouped columns that contain historical information. When I protect the sheet, I cannot expand or collapse the grouped columns. I…

asked

Anonymous

edited an answer

Anonymous

1 answer

ODBC Database sources across multiple personel and Access database queries.

Currently running linked ODBC database source tables into multiple Access queries. These tables are imported as a linked table to the source and granted permissions to them through one main password into the server. Effective February 2010, a new…

asked

Anonymous

edited an answer

Anonymous

0 answers

Graph sigmoidal curve in excel

Is there a way to plot sigmoidal data in Excel? We need to fit our dose-response data to an S-curve. Is there a plug-in for this?

asked

Anonymous

4 answers

'Insert comment' facility in protected spreadsheets gets deactivated.

When we protect a worksheet using password, insert comment option gets deactivated. Can we do something to use same in protected sheets too. Actually this option should also be made optional while saving a sheet like what we have asked for selecting…

asked

Anonymous

edited an answer

Anonymous

0 answers

Excel 2007, Protected Sheet: Runtime Error '1004' Unable to set the HorizontalAlignment property of the Range class

I have a spreadsheet that I would like to have a button that people can click that will add a row similar to the one above it. It works ok when the spreadsheet is unprotected, but once I protect it I get the Run-time error. The macro inserts a row;…

asked

Anonymous

2 answers

Outlook email hasn't worked since this morning

How long is MS outlook (email) going to be out?? When do you estimate it will be back online?

asked

Patricia ware 0

answered

Lester Bernard Reyes 86,755 Independent Advisor

Filter

Answers

Comments

1,625,047 questions

How to password protect a folder in Microsoft Office 2003

How do I bold a word or date in a formula

insert row in protected sheet by keeping formula

Macro to save as read only

Office Add In Single Sign on - Access token Expiry

Macro - Query MySQL Database with DSN-less Connection

VBA, ODBC Authentication, and Passthroughs

You cannot use this command on a protected sheet.

Can I allow macros to run on a protected sheet?

Insert row in a table on protected worksheet

COnverting multiple pages in a single Word document to individual pages

Downloadable Send to OneNote 2007 Print Driver for 64-bit System?

Images, compression, & file size

How to allow 'Group/Ungroup' on a Protected and Locked Worksheet

Expanding/Collapsing Grouped Columns/Rows When a Sheet is Protected

ODBC Database sources across multiple personel and Access database queries.

Graph sigmoidal curve in excel

'Insert comment' facility in protected spreadsheets gets deactivated.

Excel 2007, Protected Sheet: Runtime Error '1004' Unable to set the HorizontalAlignment property of the Range class

Outlook email hasn't worked since this morning