Questions

4 answers

How to refresh Pivot table on protected sheet?

Hello all, I have created a Pivot table to summarize the data entered by my team members on a different sheet. I want to give only view or print access to the Pivot table sheet for my team. If I protect the sheet with a password, an error message is…

asked

Anonymous

edited an answer

Anonymous

1 answer

Need a Macro to Encrypt All XLSX files in a folder...

Hello All, I'd like to achieve this option using a macro. I need to go for a macro because, I have a lot of .xlsx files in a folder that has to be encrypted with a password. I searched all over the web and couldn't find one. I found a macro which…

asked

Anonymous

edited an answer

Anonymous

2 answers

can not log in

trying to log in work email and will not let me, tried from phone and desktop!

asked

Kenneth Johnson 0

answered

Hani-Ng 2,845 Independent Advisor

5 answers

Breaking links on images in Word 2010 (not fields)

I use Xpert Docs to create a word document from our Quote system and it will insert images of parts, etc... When using the Alt-F9 it does change anything related to the image itself. The process is I download it in the browser, open it I can see the …

asked

Anonymous

edited an answer

Anonymous

1 answer

Object library references for Excel VBA to access Access database

According to a VBA course I took, to write VBA in Excel to access an Access database, I need to set a reference to "special object libraries". The course notes say that DAO is for Access 97 to 2003, while ADO is for 2000 to 2007. Since I use…

asked

Anonymous

edited an answer

Anonymous

37 answers

Hide VBA code in new workbook

Hi, I'd like to hide VBA code in new workbook. I have Master workbook and this is protected by password. When I protect the Master workbook, then the new workbook that I copy from Master workbook is protected too, but not VBA code in new workbook. I can…

asked

Anonymous

edited an answer

Anonymous

3 answers

Excel remove password multiple files

Hi, I have in a folder 200 excel files protected with the same password when you try open them. I would like to build a macro to remove the password to all the files at the same time which would avoid me going in each file to enter the password and…

asked

Anonymous

edited an answer

Anonymous

9 answers

Prevent user from Deleting and Re-Arranging Worksheets using Excel VBA 2013

Hi, Is there a way in VBA to prevent the user from deliberately deleting or re-arranging worksheets using Excel VBA 2013 ? Obviously, I need to prevent users from trying to mess up with the application. Can someone please help. I have found several ways…

asked

Anonymous

edited an answer

Anonymous

0 answers

problem creating AKS cluster using template in Python

I have a template for creating an AKS cluster - which works when deployed via the portal - next step to run this process in code. So, I have been looking at this azure python sample code: …

asked

AJG 341

0 answers

Automatically lock cells after inputting data

If a user enters the information in a certain cell, I want that cell to lock. I am not always around to protect and un-protect the worksheet so I need to figure out a way to make this possible. Any ideas?

asked

Anonymous

5 answers

protect shape from editing

I want to protect shape for my macro enable workbook

asked

Anonymous

edited an answer

Anonymous

2 answers

Locking Cells for editing automatically after cell is populated

Hello, I am looking for a way to lock cells for editing after the cells are populated - does anyone know of a way to do this, or could you point me in a direction? Thanks! Joe

asked

Anonymous

edited an answer

Anonymous

2 answers

Login/Password Security On A Acess Database

I have a Microsoft Access 2007 database in a network environment that is split into a front end and back end setup. I currently have a d/b password set for security as there are limited number of users, but I would like to change that to each user…

asked

Anonymous

edited an answer

Anonymous

5 answers

I got Microsoft Office Professional Plus 2013 from my university and need to re-download, but I can't.

Hey, As I said I got Office through my university through "onthehub." Recently my HDD died so I got a new SSD. Now I need Office again and I can't get it downloaded. When I try to enter my product key…

asked

Anonymous

edited an answer

Anonymous

8 answers

VBA to Loop Through Files

Hi. I have a series of identical workbooks in a folder in the following location: C:\Users\hughesel\Desktop\Test I want to create a macro which will open each of the files in turn and select all of the contents on the QPI sheet and paste special values…

asked

Anonymous

edited an answer

Anonymous

15 answers

Error 3343: Unrecognized database format 'C:\Temp\Northwind.accdb"

I am tasked with connecting to an Access DB from a Word 2010 Macro. I downloaded the Microsoft sample database and the sample verification code but that does not work either. I can open the Access database so it does not appear to be corrupted. Using…

asked

Anonymous

edited an answer

Anonymous

1 answer

VBA Code to Password protect temp excel files - autoemail

Hello Using code from Ron de Bruin I have managed to get a list of data to split into separate files and then email to different recipients baaed on the vlue in colun A. The final thing i need to do is to password protect each file before i send it. Is…

asked

Anonymous

edited an answer

Anonymous

6 answers

Office 2010 or Office 2013?

Just got a new laptop with Windows 8. I need to get a new version of Office but don't know whether to get Standard 2010 or Standard 2013. I know that there's cloud storage with 2013 which I don't really need. Which version would be best or does it…

asked

Anonymous

edited an answer

Anonymous

3 answers

Office Professional Plus 2013

I just bought a new computer with a Microsoft office 2010 on it to install or activate. But I have Office Professional Plus 2013 and it won't recognize the product key which is correct and I don't have a disk drive on new computer to download it. So…

asked

Anonymous

edited an answer

Anonymous

2 answers

Error while updating the password profile

We have been trying to hit an update user api for updating the password profile of a user. We tried to use multiple approaches. Giving the app required delegated and application permissions as mentioned in the document above. But still we are getting…

asked

Laxmi Prasanna 56

edited an answer

Laxmi Prasanna 56

Filter

Answers

Comments

1,887,935 questions

How to refresh Pivot table on protected sheet?

Need a Macro to Encrypt All XLSX files in a folder...

can not log in

Breaking links on images in Word 2010 (not fields)

Object library references for Excel VBA to access Access database

Hide VBA code in new workbook

Excel remove password multiple files

Prevent user from Deleting and Re-Arranging Worksheets using Excel VBA 2013

problem creating AKS cluster using template in Python

Automatically lock cells after inputting data

protect shape from editing

Locking Cells for editing automatically after cell is populated

Login/Password Security On A Acess Database

I got Microsoft Office Professional Plus 2013 from my university and need to re-download, but I can't.

VBA to Loop Through Files

Error 3343: Unrecognized database format 'C:\Temp\Northwind.accdb"

VBA Code to Password protect temp excel files - autoemail

Office 2010 or Office 2013?

Office Professional Plus 2013

Error while updating the password profile