A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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…
Microsoft 365 and Office | Excel | For home | Windows
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: …
Azure Kubernetes Service
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
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?
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
protect shape from editing
I want to protect shape for my macro enable workbook
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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…
Microsoft 365 and Office | Access | For home | Windows
A family of Microsoft relational database management systems designed for ease of use.
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…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
Outlook Issue
when will Outlook be fixed? Please let us know there is lots of emails that need action requried.
Outlook | Windows | Classic Outlook for Windows | For business
Using classic Outlook for Windows in business environments
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…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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…
Microsoft 365 and Office | Word | For home | Windows
A family of Microsoft word processing software products for creating web, email, and print documents.
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…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
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…
Microsoft 365 and Office | Install, redeem, activate | For home | Windows
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
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…
Microsoft Security | Microsoft Entra | Microsoft Entra ID
A cloud-based identity and access management service for securing user authentication and resource access
Get latest delta token for a mail folder
Why do you not support $deltaToken=latest for mail folder delta API? I need to pull changes to the mail folder from the current time. I am not interested in historical emails. Please let me know if that is possible or will be possible soon.
Microsoft Security | Microsoft Graph
An API that connects multiple Microsoft services, enabling data access and automation across platforms
How to connect a dedicated sql pool with azure function
I would like to know how to use python in azure function to connect to synapse's dedicated SQL pool.
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
Refreshing data on a protected worksheet
I have a workbook which is linked to several data sources. I want to be ableto protect one or more sheets so that all end users view the sheet the same (e.g stop colums widening etc). But when I do it fails to be able refresh data on that sheet? ANy ways…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Errors when protected... how to fix?!?
Ok so I thought I was done with my workbook and I start to protect everything, for realistic testing. But now in protected mode everything is giving errors because it says cells needed are protected.. even though their unlocked. So I was wondering if…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
How to allow Data Validation changes using VBA while Worksheet is protected
Hi All, I've set up a grouping of Option Buttons that have assigned macro's, these assign different PullDown lists to a specific Merged cell range in the worksheet. They work great when I have the worksheet UN-PROTECTED. When I PROTECT the…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
How to bind variables from Excel sheet to an SQL query in Excel SQL connection with Oracle
HI, In an Excel sheet I did an Oracle SQL Connection and i need to do display the following results: Select * From test_table where rownum < ??? Where ??? is equal to a data present in cell D4 of sheet 1. How do i write my SQL statement inside the…
Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.