Questions

4 answers

When a cell is changed put a time stamp and user name in another cell

Dear excel(lent) users, I am looking for the following. When cell A1 is changed I want an entry in cell D1, which states : -Which user changed cell A1 -What time did he/she change it. Something like "User xyz / 18:56". Can you please help…

asked

Anonymous

2 answers

Loop row by row to send email from excel using VBA

Hi, It is a first attempt to create project in VBA. Attached my sample code. My current code checks for row 1 and send email to corresponding users. It works fine. But I want to send an email user as row by row. Say for example if row 1 email send, it…

asked

Anonymous

2 answers

Refresh RowSource of combobox based on field on form

I need another pair of eyes to tell me what I am missing. I have a form based on a table. On that form there is a combobox with a SQL rowsource: SELECT [MPActorQ].[MovieID], [MPActorQ].[Title], [MPActorQ].[PeopleID] FROM MPActorQ WHERE…

asked

Anonymous

3 answers

SharePoint Landing Page

We have just implemented O365 SharePoint after 10 years of on premise usage and I'm struggling with a few setup issues. The most infuriating is I am trying to control the start point for anyone who clicks on the SharePoint Icon in the O 365 Apps List.…

asked

Anonymous

1 answer

How to get missing smartart layout for Excel 2010

Hello, Over the last week, I've noticed that a smartart option has disappeared from my available options in Excel 2010. I've checked on both my work and home versions and they have both 'lost' the smartart option. It's called "Picture Organization…

asked

Anonymous

2 answers

onenote android 2016 paper size to a4

how can i change paper size in onenote android 2016 to a4 instade of a3 or at least set giude lines of pages edge to be easly seen when writing??????????

asked

Anonymous

1 answer

Opening .txt files in Excel via Explorer right click doesn't work

Hi all. I've been an Office and Excel user pretty much forever, since the DOS days. I use Excel extensively for .txt and .csv file import and manipulation. In Excel 2013, you could setup the right click menu in Windows Explorer to be able to open…

asked

Anonymous

2 answers

user name stamp in excel spreadsheet (VB)

I am trying to add a username stamp (in Column P) to a spread sheet to track who changes any data in Columns A-J. I am only able to get it to work on a 1 column range (A:A). Private Sub Worksheet_Change(ByVal Target As Range) Dim Cell As Range For Each…

asked

Anonymous

1 answer

Treeview/navigation for wiki page library content for sharepoint 2013/365

Is it possible to create a treeview for wiki pages?

asked

Anonymous

5 answers

After cut and paste a text, blank spaces is automatically removed. 한글 사용자 계시면 답변 부탁드립니다

After cut and paste a Korean text, blank spaces are automatically removed within sentence from editing. How is this happen? I am using window 10 with English system. 한글 사용자 계시면 답변 부탁드립니다

asked

Anonymous

3 answers

Installed Office 365 using Admin Account, doesn't show up on other accounts

I have two accounts on my personal PC. One is an full Admin account, which I only use for installs, updates, upgrades etc. The other is a standard user account. Since I must be logged in as Admin to install programs, I used the full Admin account to…

asked

Anonymous

2 answers

links in Outlook emails that were modified by Office 365 Safe Links does not open

Split from this thread. Hi, There is another occurence of this issue from one user. Outlook mails with links rewritten by SafeLinks does not open in the browser when clicked. This is the link rewritten by SafeLinks. When clicked, below is what he…

asked

Anonymous

1 answer

VBA Code: Copy rows based on cell condition, paste rows below and repeat x number of times.

Hi All I am having some problems with creating a Macro. I have created some quick tables with dummy data to illustrate my problem. In the table below, I wish to select all rows in which a 'Yes' can be seen in column A. Hence, in this case the macro would…

asked

Anonymous

5 answers

Macro in Excel to autofill to a certain row, but from variable row?

I'd like to create a template that can copy and paste data, while autofilling data next to it. The data I have would be pasted in random amounts, so I have no set Range to reference. I have part of some code that lets me paste down to the last row of…

asked

Anonymous

3 answers

MAC Office 2016 Activation Key Limit

Hi, I had to reinstall my Mac OS and Microsoft Office multiple times (I believe around 6 or so) due to software glitches. Now when I'm launching MS Office it gives me the following error > The key associated with this account and product has been…

asked

Anonymous

6 answers

OneDrive Shared with colleagues - working fine, now no one can access the folders

I have shared a onedrive folder with a number of colleagues that are in my organization and not in my organization. This has been working fine for the last month, but today no one seems to be able to access the oneDrive folder except me. When I look at …

asked

Anonymous

5 answers

Modifying Table Style - Header Row Font

Hi I am using word 2016 and I am having issues creating/modifying table styles. What I what to do is create a table style where the header row font is different to the font in the other rows of the table. So, in the Modify Table style dialog box I…

asked

Anonymous

4 answers

'A corrupted item was encountered: Folder ACL' During Office365 Mailbox Migration

Hi, I am attempting to move my mailbox from my companies Exchange 2013 server to our Office 365 environment. The migration failed citing "Request ‎'‎ has already encountered more than ‎'11‎' bad items and can‎'t be given a limit of ‎'10‎'." The…

asked

Anonymous

9 answers

Edit styles in one place, change styles in multiple documents

Hi, I would like to be able to edit styles once, and let the styles be implemented in multiple word documents. For example, I would have a folder with 20 existing Standard Operating Procedures. I would like to change the Heading 1 style to have another…

asked

Anonymous

2 answers

Sheets.PrintOut in VBA using Excel for the Mac 2016

Hi gang, I'm trying to use a VBA Macro within Excel for the Mac 2016 (Version 15.22). I *think* that VBA commands are documented at: https://msdn.microsoft.com/en-us/library/office/ff838253.aspx But perhaps this is only for the Windows…

asked

Anonymous

Filter

Content

1,702,362 questions

When a cell is changed put a time stamp and user name in another cell

Loop row by row to send email from excel using VBA

Refresh RowSource of combobox based on field on form

SharePoint Landing Page

How to get missing smartart layout for Excel 2010

onenote android 2016 paper size to a4

Opening .txt files in Excel via Explorer right click doesn't work

user name stamp in excel spreadsheet (VB)

Treeview/navigation for wiki page library content for sharepoint 2013/365

After cut and paste a text, blank spaces is automatically removed. 한글 사용자 계시면 답변 부탁드립니다

Installed Office 365 using Admin Account, doesn't show up on other accounts

links in Outlook emails that were modified by Office 365 Safe Links does not open

VBA Code: Copy rows based on cell condition, paste rows below and repeat x number of times.

Macro in Excel to autofill to a certain row, but from variable row?

MAC Office 2016 Activation Key Limit

OneDrive Shared with colleagues - working fine, now no one can access the folders

Modifying Table Style - Header Row Font

'A corrupted item was encountered: Folder ACL' During Office365 Mailbox Migration

Edit styles in one place, change styles in multiple documents

Sheets.PrintOut in VBA using Excel for the Mac 2016