![]() |
|
#1
|
|||
|
|||
![]()
Thank you for your reply. I have added one of my macros which sometimes encounters this error. (as I told, this issue is not related for a particular macro. And strangely it sometimes even occurs when I try to copy (move) sheets manually (without using macro))
Option Explicit Sub saveboursview() Dim ws0 As Workbook Dim name0 As String Application.DisplayAlerts = False Set ws0 = ActiveWorkbook Windows("tempalatecodal.xlsb").Activate UserForm1.Show name0 = Range("a1").Value ws0.Activate ActiveSheet.Copy Before:=Workbooks("tempalatecodal.xlsb").Sheets("u serform") ActiveSheet.name = name0 Application.Run "'Personal.xlsb'!bourseview" Application.Run "'Personal.xlsb'!replace0" ws0.Close Application.DisplayAlerts = True End Sub Last edited by soroush.kalantari; 10-17-2023 at 07:51 PM. |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
One veryhidden sheet, one hidden sheet and two visible sheets - how to saveas into .xlsm workbook | kiwimtnbkr | Excel Programming | 4 | 06-26-2019 11:30 AM |
![]() |
rsrasc | Excel Programming | 4 | 08-19-2018 04:00 PM |
![]() |
nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
![]() |
Sinister | Excel | 4 | 04-08-2014 05:53 PM |
Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |