Excel 2007 :: How To Adjust Protected View Settings But Protected View Tab Is Missing From Trust Centre Settings
Dec 12, 2013
Excel 2007 - need to adjust protected view settings but the protected view tab is missing from my Trust Centre settings - have the following tabs - trusted publisher / location, add-ins, activeX, macro, message bar, external content and privacy options. Document is a revenue authority download and without being able to adjust the protected view settings, can't input data.
View 3 Replies
ADVERTISEMENT
Nov 14, 2012
I have a large spreadsheet from which I need to create separate Reports by hiding various rows and columns. I have followed instructions for creating a couple of Custom Views (View tab, Custom Views, Add, Inserted Name, OK, Saved the document) but nothing happens apart from getting the message "Some view settings could not be applied". In fact none of the view settings were applied.
View 1 Replies
View Related
Oct 18, 2006
I have a battery sizing workbook, which has various tables and active cell VBA routines, that enable the user to input a number and then select a cell from the table presented on the front worksheet. This will then display the solution including other data. I have now been requested to share the workbook and all I seem to do is lock it up and therefore stop and calculations. Therefore your assistance is required in two area's:-
1. How to protect the workbook and allow the user to select a cell on the front worksheet, without all the all the VBA routines appearing to grind to a halt! I can lock an hide all the subsequent worksheets without freezing the front worksheet.
2. I can hide all the toolbars, row and column headings under my Tools/Options which will display the worksheet neatly...... Therefore can I some how instruct the users Excel to turn these off when loading?
View 2 Replies
View Related
Mar 12, 2014
There are some excel documents in a hidden folder that contain sensitive information. Shortcuts to these documents will be provided to users to open them and add data. These documents contain all kinds of macros as well. Once macro disables the 'Save As' feature so that the workbook can not be saved outside of the hidden folder, preventing to some degree a user from saving as a different name and emailing the document with the sensitive data.
This all works fine with Macros enabled. As soon as macros are disabled the 'Save As' prevention is bypassed and the workbook can be saved anywhere.
Is there a way for an administrator to lock out the Trust Center options for disabling all macros?
View 9 Replies
View Related
Jan 14, 2010
I tried to use the code that allows macro to run even when the sheet is protected.
View 3 Replies
View Related
Nov 29, 2007
I have a workbook with 3 spreadsheets. When I put ptotection on 2 of the sheets, the custom view will not work on the other. Any way to make the views work?
View 5 Replies
View Related
Apr 12, 2013
A client has sent me an Excel workbook that appears on the screen with the message adivising that it is Protected View as a result of having been downloaded from the internet. If I click on the Enable Editing button the workbook is completely deactivated. I have played around with my Trust Centre settings but nothing seems to work.
View 1 Replies
View Related
Feb 3, 2014
Opening several files and combining them into 1 workbook. The files will not open - due protected view......
How do I allow the files to be opened to be copied?
View 5 Replies
View Related
Oct 9, 2011
Is there any way to change the settings in excel 2007, to give me the original color palate from 2003? I want to use the old colors because I don't like the new ones.
View 2 Replies
View Related
May 19, 2008
The following line of VBA code executes properly if machine settings are US English, but throws a "Run-time error '1004': Application-defined or object-defined error" ? ...
View 9 Replies
View Related
Jun 14, 2013
how to change the default settings for shapes in Excel 2007? I select a line tool and it is a blue color and I would like to have its default as black
View 6 Replies
View Related
Sep 28, 2011
I am having trouble getting Excel 2007 on my work computer to save as .xlsx by default.
I have opened the Office Button > Excel Options > Save > Save files in this format and selected "Excel Workbook (*.xlsx)," and if I save as before closing Excel then it works perfect and saves the file as .xlsx. However if I close Excel, re-open it later and save a new file the default "Save as type:" is "Excel 97-2003 Workbook (*.xls)" and if I open the save options again the "Save files in this format" option is reverted back to "Excel 97-2003 Workbook (*.xls)."
I have finally overcome the [Compatibility Mode] issue by saving a file named "Book.xltx" (not "Book1.xltx") in the two default locations "C:Program FilesMicrosoft OfficeOffice12XLSTART" and "D:Documents and SettingsusernameApplication DataMicrosoftExcelXLSTART" (we use the D: drive at work for personal files). I thought this would solve the save as issue but it hasn't. I have also changed the "Save files in this format" before saving the .xltx files in the locations to apply the settings to those specific files but that hasn't worked.
It is on my work computer so I am limited in what settings I can change because they have them pretty well locked down.
View 7 Replies
View Related
Feb 11, 2012
In an effort to manipulate the xml documents within an xls, you used to be able to change the extension to .zip then open. This no longer works for me, just getting the 'cannot open file: it does not appear to be a valid archive.
I have tried it with a number of different files, but no joy.
It still works with a .doc so I guess it's not that Microsoft have stopped this capability?
Using Excel 2007
View 2 Replies
View Related
Mar 13, 2008
I have a macro with "ActiveWorkbook.Protect Password:="password"" . It was working fine in excel 2003. In excel 2007, because of this I am not able to run any macro's in the workbook. I am getting a message "The macro may not be available in this workbook or all macros may be disabled. I can see a security warning in message bar saying macros have been disabled, but I dont have have a option to enable the macros.
View 9 Replies
View Related
Oct 24, 2012
Excel 07
I inserted a hyperlink into a cell that goes to a web page. It works when the sheet is NOT protected, as soon as I protect the sheet it stops working. How do can I lock the workbook and that cell so nobody can change it but the hyperlink still work?
View 2 Replies
View Related
Apr 9, 2014
Is it possible to adjust column width of a PW protected worksheet without unprotecting it, or unprotect it and adjust in background then PW protect it?
On sheet1 H1 = column width value
Will adjust Sheet2 (password protected) column E width
View 9 Replies
View Related
Aug 20, 2013
I am working on lots of excels, with data queries from sql and pivot tables. Is there a way to set defaults to some settings in excel (not in this specific file).
To be more specific:
1. Import data from SQL: Refresh on opening, save password
2. Formatting of number to have two digits and a comma separator
3. Pivot table: when adding to values sum instead of count, refresh when opening the file
View 1 Replies
View Related
Sep 5, 2012
When I place a text box in Excel 2010, the default is for everything to be locked (Box is locked AND text is locked). I want to change the default setting so that when I start Excel fresh, anytime I place a text box the "LOCK TEXT" box is UNCHECKED.
There's a place where you can select "Set as default text box") after you make the changes, but it's not sticking (even in the same document without closing. IE, I make the changes to a text box, then click the option that says "Set as default text box", place a NEW text box immediately in the same document but the text is still locked.
View 3 Replies
View Related
Aug 16, 2013
I'm using the following code to create a customized userform, and it works perfectly on my computer, as I've enabled all macro settings.
Code:
Function GetOption(OpArray, Default, Title)
Dim TempForm 'As VBComponent
Dim NewCheckBox As MSForms.CheckBox
Dim NewLabel As MSForms.Label
Dim NewCommandButton1 As MSForms.CommandButton
[Code] .......
However when my coworkers need to use the code it creates an error, as the VBA project is unsafe.
Now my question is, can you write some code that enables all macro settings temporarily, in such a way that my coworkers can use this code?
View 4 Replies
View Related
Apr 23, 2012
My office recently upgraded to Office 2010 and we would like (in the accounting department that I work in) to change the default number formating in a blank sheet to Number, 0 Decimals, using seperators, from the current default of general format number.
I have looked for the Book.xltx file to replace but can't see it any where.
View 5 Replies
View Related
Jan 10, 2014
I have 3 Excel files open. There's one unnamed file that I can open in the background with no problem. Then I have 2 data files. I'd like to be able to view them both at the same time, side by side, but for some reason I cant. They both seem to occupy the same window. Every time I goto the task bar and try switching windows they occupy each other's window. Is there a way to view files side by side?
View 2 Replies
View Related
Jun 15, 2009
I have a workbook that many moons ago I protected. Now I want the workbook to be an unprotected workbook so many users can view and update if necessary.
Typically I know you are supposed to go to: Review, Changes, Unprotect Workbook. But all that is available is to protect the workbook, but it is already protected. I know this because every time I open the workbook, I am prompted to enter a password.
Is there another way to remove this workbook protection I do not know about?
View 9 Replies
View Related
May 22, 2013
I have MS Office 2010 Home Edition. Is there a way to make 2 different Excel docs show up on 2 different monitors at the same time (one on each, of course)? (I have a PC and 2 displays total.)
View 3 Replies
View Related
Apr 18, 2012
I have got a table, with a range B1:CC200. I have been able to run a macro which pops up a form and shows the particulars of a selected month corresponding to those in the table. (e.g., say entries in column D pertaining to say, March 2012 are shown in the form). Problem is I want to be able to update the entries using the form, but no no success. Am quite new to vba but the code I tried to use on the command button after updating is shown below
Private Sub CommandButton1_Click()
TextBox1.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B2:CC2"))
TextBox2.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B3:CC3"))
.
.
.
TextBox20.Value = Application.Lookup(Range("A1"), Range("B1:CC200"), Range("B20:CC20"))
Unload Me
End Sub
Where A1 is the month in question, B1:CC200 the range of the database and row B2:CC2, and B3:CC3...., B20:CC20the data I need to update. .
View 1 Replies
View Related
Apr 9, 2014
I believe that someone showed me once that you could view the same workbook on two monitors with the vien arrange all mode, you could make changes on both screens and the changes would be saved to the same file similar to arranging two views. I cannot rememebr how to do this or even if it is possible.
View 5 Replies
View Related
Apr 18, 2013
I have hide workbook in view and hide option, when i unhide the same it should ask password. Is it possible.
View 1 Replies
View Related
Dec 14, 2012
How can I view hidden characters inside an excel cell. I have an excel file that I receive from our vendors. After verifying the data, I save the file as a tab delimited .txt format. When I open the .txt file I see some data with " " at both ends. i.e. "800 North Ave. Suite A". The thing is I don't see the " " in excel. This tells me that these are non-printing characters.
View 4 Replies
View Related
Feb 26, 2014
what I would like to do is view a cell result in my userform with out deleting my formula
It works perfect from the excel side but I just cant get it right from the user form side
Ok so cell D6 contains a vlookup formula. I want the vlookup result to appear in my userform. I can get this to work but it overrides the vlookup formula with the result. This means that when I go to use it again it just shows the same result.This is what I have:
Cell D8 has a Combobox with a list of names to select from
this is the formula in cell D6 =VLOOKUP(D8,B107:I754,2,FALSE) This retrieves the selected customers account number from the combobox. I need my userform to display the account number with out erasing the formulas because I will need to search for more account numbers after.
I have named the textbox in my userform Customeraccountb
View 3 Replies
View Related
Jan 6, 2012
I'm used to work with the Excel 2003 edition, however I just changed the version to 2010. As result of that I do have the following question:
How can you view the source data of a pivot table in Excel 2010?
View 6 Replies
View Related
Sep 3, 2013
I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies
View Related
