Hi Vic
Attached is the template with no data.
I suggest you test with the empty template first before adding any data to see if the problem is happening again.
Good luck.
Sunny
Hello Sunny,
Thanks for the prompt request. I am grateful. I have been trying to attach a video of the problem i am having but i cannot attach the file. That would have helped. If it is not against the policy of this forum, I can send you the video if you provide an e-mail address to send it to. The video would help you understand the problem I am facing. The video is just 4mb and it is not getting attached.
I look forward to hearing from you soonest as always.
Thanks for your usual assistance.
Vic
Hi Vic
Did you try my latest attachment hat I did from scratch?
I believe it is against the Forum policy to contact me personally but you may need to discuss with the Administrators.
Maybe you could send the file to them and they send it to me. Just maybe.
Sunny
Hi Vic,
You can use something like YouTube, Vimeo or Daily Motion to host your video and then link to it here.
Regards
Phil
Ahhh a brilliant idea Philip!!!!
Now everyone can see the problem and chip in with their solutions.
🙂
Hello everyone,
This is the video link as suggested. I was not able to upload here still.
Sunny, yes. I used the last file you sent to me and that's the same file i used in creating the video.
Thanks everyone
Hi Vic
I have viewed the video numerous times but still unable to spot the cause.
My first impression was it could be caused by grouping of the sheets.
I did notice that you did not use a mouse but using the keyboard. Maybe some key combination is causing a problem?
Although the text "disappeared" from the screen, if you select the cell again can you see the text in the formula bar?
I thought I saw it on the formula bar.
The problem also did not occur when all the sheets are displayed. This could also be an indicator.
It may also be a technical issue (bug?) which I am unable to assist.
I can't replicate the issue no matter how hard I tried.
I am using Excel 2010 and my file is stored in a local drive.
Maybe some other members can help.
Sorry.
Sunny
Hi Vic,
I tested Sunny's File; Vic-hid-sheets.xlsm in Excel Office 365 and can't reproduce the problems shown in your video. I wonder if it's some obscure region settings causing the bugs.
It certainly looks buggy, because (as Sunny pointed out) after you enter text in the cell and press Enter, which moves the active cell down one, the text is still visible in the formula bar.
Mynda
Hi Vic,
I can't reproduce your problem either. Given that 4 of us with different PC's and versions of Excel can't reproduce your problem it looks like either an issue with your setup, or a bug that is so obscure we can't easily recreate it. You have said that you've tried Excel 2013 and 2016 and on different PC's so I'm stumped.
I'm using 32-bit Excel 2013 (15.0.5093.1000).
Exactly what versions did you test with? 32 or 64 bit?
What add-ins have you got installed?
Although you said you uninstalled/reinstalled excel that's not the same as doing a clean install on a new PC. An uninstall can leave behind a lot of files that affect what you think is a clean reinstall.
You'd be best off installing Excel onto a PC that has never had it on before, without any add-ins, and testing that. Can you describe your environment? Are you in a corporate environment with servers/domains? Any security/restrictions on the PC's?
I've tweaked a couple of bits of the code in the blank template that Sunny provided, please see if this helps.
Regards
Phil
Hello everyone,
Thanks for the concern as always. much grateful.
Sunny, to answer your questions,
1. The sheets are not grouped
2. I actually used mouse for the insertion of columns which did not work.
3. The problem did not occur when all the sheets are displayed because I was logged in as an admin and like I said before, the problem is only with user1 and user2. Admin users do not have the problem.
Hello Mynda, yes, the texts are still visible in the formula bar here. I wonder why.
Phil,
I completely uninstalled office 2013. deleted all folders associated with it before installing office 2016 (64-Bits). I do not also have any add-ins installed.
As per the security, though this is going to be used by different users in the later days and would require the use of a server. But that is not happening now as I am currently working on my laptop (Personal Laptop) and not the company's official system. So to answer your question, there are not restriction of any kind.
I have also gone through your file Phil. Sadly, the problem is still there and I am beginning to think there is a bug issue.
However, I did try something though which is just one extra work anyway but i am fine with it as long as it works. I created another line of code (UnprotectAllSheet) and I gave a shortcut of Shift+Ctr+U. This is developed only for User1 & User2. This code prompts the users to enter their login password to unprotect the sheet even though the sheets were not protected apart from the visibility. Its funny though but surprisingly, it works.
Once User1 or User2 logs in, they just press the shortcut and they enter the password and they are good to go. So on the first row of the SRRV and SIV sheet, I wrote a comment for the user to do this. I will keep trying to see if I can work my way around the disappearing sheet anyway but for now, I am okay with what I have been able to come up with.
Once again, I am super super grateful for everyone who contributed to this. you are all loved. I joined this forum just recently and it has been so so active and i have received help from different people. I still have more to share with you guys soonest.
Thanks all
Vic.
Hi Vic,
I don't understand what you have done with 'UnprotectAllSheet'. If you can share the workbook with the new code it might offer some clues.
You said previously that you tried other machines and had the same issues. What was the config of these PC's?
Regards
Phil
Hi Vic
Did you try and create your own file using my codes?
Does it give you problem?
This is the final sheet that i added the UnprotectSheet macro.
I have not tried creating another file with the code you provided. I would do that today.
Hi Vic,
The VBA module in your workbook is password protected so I can't look at it.
I never run VBA without checking it over first.
Phil
